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, 5 of 26


AND (&)

Use the AND operator to search for documents that contain at least one occurrence of each of the query terms.

Syntax

Syntax  Description 

term1&term2

term1 and term2 

Returns documents that contain term1 and term2. Returns the minimum score of its operands. All query terms must occur; lower score taken. 

Examples

To obtain all the documents that contain the terms blue and black and red, issue the following query:

'blue & black & red'

Notes

In an AND query, the score returned is the score of the lowest query term. In the example above, if the three individual scores for the terms blue, black, and red is 10, 20 and 30 within a document, the document scores 10.


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