Hi Everyone
,
I am trying to get the value from the table(employee)connecting through
the oracle database. Since there are 100s of values in one column, i would
need to
iterate the table and get the exact value.
I have the code that works if i use the index no. such as row[1] but i
wanted to use the column_name "first name" instead of row[1]. Below is
the code that i have which works.
require 'rubygems'
require 'oci8'
$connection = OCI8.new('usrname', 'password', '//hostname:portno/sid')
person=$connection.exec("SELECT EMP_ID from Employee") do |row|
puts "#{row[1]}"
end
I get the result succesfully but i want to get the result not with
row[1] but with the row with the respective column_name.
Can anybody help me on this? Any little bit of help would be highly
appreciated.
Regards,
Ashok Tulachan
--
Before posting, please read http://watir.com/support. In short: search before
you ask, be nice.
[email protected]
http://groups.google.com/group/watir-general
[email protected]
