Category Archives: oracle

Installing the Ruby Bindings for Oracle on Mac OS X

Posted on March 4, 2010 by Daz

This quick crib sheet is for the guys at work (and anyone else who might need help on this one)… First install the oracle instant client somewhere - I normally install it to /usr/local/oracle/instantclient_10_2. Then… cd /usr/local/oracle/instantclient_10_2 ln -s libclntsh.dylib.10.1 … Continue reading →

Posted in mac, oracle, ruby | Tagged , , , , | Leave a comment

Remove Case-Sensitivity in Oracle

Posted on October 18, 2007 by Daz

Oracle is a great RDBMS, but the fact that searches against the database are case-sensitive can be a pain in the butt. Here’s how you can make searches case-insensitive…

Posted in oracle, perl | Tagged , | Leave a comment

MySQL 4.X to Oracle Notes

Posted on October 11, 2007 by Daz

Stumbled across this useful page full of examples and notes on how MySQL 4.x and Oracle differ, and how you can avoid complications if you want to migrate a database between the two… About once a year I need to … Continue reading →

Posted in mysql, oracle, snippets | Tagged , , | Leave a comment

Log/Audit Tables in Oracle

Posted on October 5, 2007 by Daz

One of the useful things that i’ve been asked to set-up lately is automatic logging of changes to several of our database tables. My first thought was to do this in Perl (as the rest of the system is in … Continue reading →

Posted in noteworthy, oracle | Tagged , | Leave a comment

Auto-Increment ID’s in Oracle

Posted on October 4, 2007 by Daz

This is old news to most people who have been using Oracle for a while, but to me this is something new that I learnt today. How to have MySQL like “auto-increment” id’s for your tables in Oracle. Here’s an … Continue reading →

Posted in noteworthy, oracle | Tagged , , | Leave a comment