An Oracle Text index is an Oracle Database domain index. To build your query application, you can create an index of type CONTEXT with a mixture of text and structured data columns, and query it with the CONTAINS operator.
You create an index from a populated text table. In a query application, the table must contain the text or pointers to where the text is stored. Text is usually a collection of documents, but can also be small text fragments.
This tutorial covers the following:
-
Creating a CONTEXT Index and Querying with CONTAINS operator
-
Creating a CTXCAT Index and Querying with CATSEARCH operator
-
Creating a CTXRULE Index and Querying with MATCHES operator
Release Date: 28-Jan-14
Duration: 20 minutes
Credited To: -
No Flash Plugin Needed