Top Page

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.

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."