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

Special Characters in Queries, 4 of 4


Reserved Words and Characters

The following table lists the interMedia Text reserved words and characters that must be escaped when you want to search them in CONTAINS queries:

Reserved Word  Reserved Character  Operator 

ABOUT 

(none) 

ABOUT 

ACCUM 

Accumulate 

AND 

And 

BT 

(none)  

Broader Term 

BTG 

(none) 

Broader Term Generic 

BTI 

(none) 

Broader Term Instance 

BTP 

(none) 

Broader Term Partitive 

(none) 

fuzzy 

(none) 

{ } 

escape characters (multiple) 

(none) 

escape character (single) 

(none) 

( ) 

grouping characters 

(none) 

[ ] 

grouping characters 

MINUS 

MINUS 

NEAR 

NEAR 

NOT 

NOT 

NT 

(none) 

Narrower Term 

NTG 

(none)  

Narrower Term Generic 

NTI 

(none) 

Narrower Term Instance 

NTP 

(none) 

Narrower Term Partitive 

OR 

OR 

PT 

(none) 

Preferred Term 

RT 

(none) 

Related Term 

(none) 

stem 

(none) 

soundex 

SQE 

(none) 

Stored Query Expression 

SYN 

(none) 

Synonym 

(none) 

threshold 

TR 

(none) 

Translation Term 

TRSYN 

(none) 

Translation Term Synonym 

TT 

(none) 

Top Term 

(none) 

weight 

(none) 

wildcard character (multiple) 

(none) 

wildcard character (single) 

WITHIN 

(none) 

WITHIN 


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