Rails console sql query only returns true

Question

I am issuing an SQL statement in console:

> sql = "SELECT flavour from Libation where id=8675309"
> result = ActiveRecord::Base.connection.execute(sql)
=> true

Am using the oracle enhanced adapter, and wonder why I only get true. I was expecting something like "mango". I have tried many things and no luck.

Answer 1

Use select_all instead of execute to fetch results.