Related Entries

MPP to SQLite via Ruby

« Programming Links
» Wink

Oracle with Active Record

Thanks to ActiveRecord, it is a breeze to program Oracle using Ruby. Here's a quick note about how to do this on MS Windows.
  1. Install Ruby
  2. Install Active Record. Open a DOS shell and run gem install activerecord.
  3. Install OCI8 driver for Ruby. Download ruby-oci8-mswin and double click it.

Assuming you’ve standard scott/tiger schema on some Oracle connection (the TNSNAMES.ORA entry in the example below is named as development), here is a small sample script that shows how to manipulate the data in one table.

Name this as oracle_sample.rb and run it. See how easy it is? Now is a good time to explore Active Record Documentation and explore the other cool things possible. Toss out your Pro*C reports today and switch to Ruby with Active Record.