Oracle Text CONTAINS Query Operators

This chapter describes operator precedence and provides descriptions, syntax, and examples for every CONTAINS operator.

This chapter contains the following topics:

• Operator Precedence

• ABOUT

• ACCUMulate ( _ )

• AND (&)

• Broader Term (BT_ BTG_ BTP_ BTI)

• CTXFILTERCACHE

• DEFINEMERGE

• DEFINESCORE

• EQUIValence (=)

• Fuzzy

• HASPATH

• INPATH

• MDATA

• MINUS (-)

• MNOT

• Narrower Term (NT_ NTG_ NTP_ NTI)

• NDATA

• NEAR (;)

• NEAR2

• NOT (~)

• OR ()

• Preferred Term (PT)

• Related Term (RT)

• SDATA

• soundex (!)

• stem ($)

• Stored Query Expression (SQE)

• SYNonym (SYN)

• threshold (>)

• Translation Term (TR)

• Translation Term Synonym (TRSYN)

• Top Term (TT)

• weight (*)

• wildcards (% _)

• WITHIN

• Supported Oracle Text CONTAINS Query Operators for In-Memory Full Text Search