Oracle8i interMedia Text Reference
Release 2 (8.1.6)

A77063-01

Library

Product

Contents

Index

Prev Up Next

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.


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index