A structured query, also called a mixed query, is a query that has a
CONTAINS predicate to query a text column and has another predicate to query a structured data column.
To enter a structured query, you specify the structured clause in the
WHERE condition of the
For example, the following
SELECT statement returns all articles that contain the word oracle that were written on or after October 1, 1997:
SELECT SCORE(1), title, issue_date from news WHERE CONTAINS(text, 'oracle', 1) > 0 AND issue_date >= ('01-OCT-97') ORDER BY SCORE(1) DESC;