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


EQUIValence (=)

Use the EQUIV operator to specify an acceptable substitution for a word in a query.

Syntax

Syntax  Description 

term1=term2

term1 equiv term2 

Specifies that term2 is an acceptable substitution for term1. Score calculated as the sum of all occurrences of both terms. 

Examples

The following example returns all documents that contain either the phrase alsatians are big dogs or labradors are big dogs:

'labradors=alsatians are big dogs'

Notes

The EQUIV operator has higher precedence than all other operators except the expansion operators (fuzzy, soundex, stem).


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