Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Indexing multiple columns from same table

202565Apr 14 2003 — edited Apr 14 2003

Greetings all,

I'm very new to Oracle Text so please be patient. I have a SQL Server background and am trying to setup a full-text search on an Oracle 8.1.7 database. In SQL Server I can run a query as follows 'SELECT * FROM TABLE WHERE CONTAINS(*, 'Search Phrase AND Search Phrase 2')' and would like to do something similar on Oracle. It appears to me that there isn't a straight forward way to run a contains clause without having to specify the exact column name(s). The web application I am working on has the ability to dynamically add and remove fields from tables and integrate them into the full text indexes, so I need to be able to specify the wildcard * character. Is this doable in OracleText. I have seen 'Multi Column Datastores' and am deathly confused by all of it. Thanks for any help.

Cheers,
Greg.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 12 2003

Added on Apr 14 2003

#database-key-features, #text

1 comment

285 views