shijiang1130 发表于 2010-11-22 10:58

ruby 连接oracle

ruby -r oci8 -e "OCI8.new('scott','tiger').exec('select count(*) from user_tables') { |r| puts r}"

shijiang1130 发表于 2010-11-22 13:48

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]
查看完整版本: ruby 连接oracle