And you can search either in all columns or specify in which column you want to search (as first argument you need to specify first column name as this is the column which is referenced during index creation): See Oracle Text documentation for syntax that you can use in CONTAINS function in SELECT WHERE clause.
You can also specify some dummy main column name when creating multiple column index as well as specify to update index automatically after each commit (as otherwise you need to synchronize index manually or schedule periodic update): Or you can specify that index should be updated when specified columns are updated (e.g.
Oracle enhanced adapter for Active Record Oracle enhanced Active Record adapter provides Oracle database access from Ruby on Rails applications.
Oracle enhanced adapter can be used from Ruby on Rails versions between 2.3.x and 5.2 and it is working with Oracle database versions from 10g to 12c.
I explain the mapping of the Date and Time API classes in more details in: Hibernate 5: how to persist Local Date Time and Co with Hibernate.
Get more recipes like this one in my new book Hibernate Tips: More than 70 solutions to common Hibernate problems.
To create simple single column index create migration with, e.g.
Oracle enhanced adapter maintains API backwards compatibility during patch version upgrades and therefore it is safe to always upgrade to latest patch version.