Oracle Text Reference Release 9.0.1 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.
MATCHES([schema.]column, document VARCHAR2 or CLOB,RETURN NUMBER;
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.
Oracle Text Application Developer's Guide
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|