If you have an appropriate system-defined role (CTXSYS or CTXAPP), you can use interMedia Text to enable text queries in a query application. The following is a simple example of using interMedia Text:
INSERT INTO docs VALUES (2, 'second document');
COMMIT;
INDEXTYPE IS CTXSYS.CONTEXT;
This will find all rows in docs where the text column contains the word first (which is document 1). The > 0 part of the statement is necessary to make it valid Oracle SQL, which does not support Boolean return values for functions.
Additional information is available about the following topics:
These topics merely get you started, however. To use interMedia Text effectively, you must understand the major concepts. It is also recommended that you have the product documentation available.
See also: Main topics (outline), Major concepts for interMedia Text