What is ruby-oci8

Ruby-oci8 is a ruby interface for Oracle Database. The latest version is available for all Oracle versions after Oracle 9i including Oracle Instant Client.

If you need to use Oracle 8, use ruby-oci8 2.0.6.

As for Oracle7, use Oracle7 Module for Ruby by Yoshida Masato.

What's new

See NEWS.

Sample one-liner

Connect to scott/tiger, select emp and print as CSV format.

ruby -r oci8 -e "OCI8.new('scott', 'tiger').exec('select * from emp') do |r| puts r.join(','); end"

If you install a ruby-oci8 gem package, you may need to add -rubygems before -r oci8.

Installation

Report issues