The Oracle (tm) Users' Co-Operative FAQ

If I store text in a column, can I index individual words ?.


Author's name: Michael Eichler

Author's Email:meichler@proteus.com

Date written: 4th March 2002

Oracle version(s): 8.1

If I store text in a column, can I index individual words ?

Back to index of questions


This is possible if you use the Oracle interMedia Text option.  It allows you to create "text indexes" on your text columns which can then be queried using the contains() function in the where clause.


Further reading: N/A


Back to top

Back to index of questions