I am trying to get the value from the table(employee)connecting through
the oracle database. Since there are 100s of values, 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 but i
wanted to use the column_name “first name” instead of row. Below is
the code that i have
$connection = OCI8.new(‘usrname’, ‘password’, ‘//hostname:portno/sid’)
person=$connection.exec(“SELECT * from Employee”) do |row|
I get the result succesfully but i want to get the result not with
row but with the row with the respective column_name.
Can anybody help me on this? Any little bit of help would be highly