|Oracle Text Reference
Part Number A90121-01
SQL Statements and Operators, 7 of 8
Use this operator to find all rows in a query table that match a given document. The document must be a plain text, HTML, or XML document.
This operator requires a CTXRULE index on your set of queries.
MATCHES returns 1 for one or more matches and 0 for no match.
Specify the column containing the indexed query set.
Specify the document to be classified. The document can be plain-text, HTML, or XML. Binary formats are not supported.
Assuming that a table
querytable has a CTXRULE index associated with it, you can issue the following query that passes in a document string to be classified. The SELECT statement returns all rows (queries) that are satisfied by the incoming document:
SELECT classification FROM querytable WHERE MATCHES(text, 'Smith is a common name in the United States') > 0;
Syntax for CTXRULE Indextype in this chapter.