Every once in a while you'll come across the need to create a temp table to perform a complicated select query. Not being a big fan of creating these temp tables, I came up with a better solution. Leveraging Postgresql's array structure, I wrote a function that converts a varchar[] to a record [...]
This weekend I was playing around with Ubuntu 7.04 and Compiz-Fusion, I didn't have any major problems until I tried to get Oracle SQL Developer and Aqua Data Studio to work, they would start up but no interface would be drawn.
Well the problem is that they were trying to figure out the Window Manager for [...]
This tool seriously rules, it allows you to test your java regex and automatically escapes it, saving tons of time. The only downside is it's an applet? Yea, an applet remember those?
Regular Expression Tester
Bookmark to:
During the last week or so I've been going through the process of setting up an Oracle 10g database on CentOS 4.5. Rather than relying on the toads at OTN or the raving throngs of confusion at the oracle.com forums for advice. I learned everything I needed to know at Dizwell Informatics. It's the site [...]
For some reason in the latest 10g oracle download for linux they fubared the perms for the $ORACLE_HOME directory, not allowing non-oracle users to run any oracle client tools like sqlplus. Causing awesome errors like:
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
Also this completely broke oci8 [...]
