Oracle8i interMedia Text Reference
Release 2 (8.1.6)

Part Number A77063-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Query Operators, 12 of 26


NOT (~)

Use the NOT operator to search for documents that contain one query term and not another.

Syntax

Syntax  Description 

term1~term2

term1 not term2 

Returns documents that contain term1 and not term2

Examples

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)'


Note:

The NOT operator does not affect the scoring produced by the other logical operators. 



Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index