Oracle Text Reference Release 9.0.1 Part Number A90121-01 |
|
CONTAINS Query Operators, 14 of 28
Use the NOT operator to search for documents that contain one query term and not another.
Syntax | Description |
---|---|
term1 not term2 |
Returns documents that contain term1 and not term2. |
To obtain the documents that contain the term animals but not dogs, use the following expression:
'animals ~ dogs'
Similarly, to obtain the documents that contain the term transportation but not automobiles or trains, use the following expression:
'transportation not (automobiles or trains)'
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|