Oracle Text is well-known as the text searching engine within Oracle Database 12c. Oracle Text provides indexing, word and theme searching, and viewing capabilities for text in query applications and document classification applications. It is easy to use in any application which understands SQL and it is based on the extensibility framework within the Oracle kernel. Oracle Text is multilingual, and capable of managing many types of document.

This tutorial covers the following topics:

• How to create a user with the CTXAPP role.
• How to build simple text query.
• It also provides information about basic SQL statements for each type of application to load, index, and query tables.

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

This tutorial introduces you to the basics of Oracle Text theme indexes and queries. It can all be run from SQL*Plus or SQL Developer and requires no additional files.

This tutorial covers the following:

• Enabling Oracle Text Section Searching
• Oracle Text Section Types
• HTML Section Searching with Oracle Text
• XML Section Searching with Oracle Text