ruby 连接oracle
ruby -r oci8 -e "OCI8.new('scott','tiger').exec('select count(*) from user_tables') { |r| puts r}" require 'dbi'dbh = DBI.connect('DBI:OCI8:ORCL', 'hr', 'hr')
rs = dbh.prepare('SELECT * FROM states')
rs.execute
while rsRow = rs.fetch do
p rsRow
#Alternative output: puts rsRow
#Alternative output: pp rsRow
end
rs.finish
dbh.disconnect
页:
[1]