Oracle8i interMedia Text Reference
Release 2 (8.1.6)

A77063-01

Library

Product

Contents

Index

Prev Up Next

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 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index