Oracle Text Reference
Release 9.0.1

Part Number A90121-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

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

CONTAINS Query Operators, 5 of 28


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-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback