| Oracle8i interMedia Text Reference Release 2 (8.1.6) Part Number A77063-01  | 
  | 
Query Operators, 12 of 26
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-2000, Oracle Corporation. All Rights Reserved.  | 
 
  |