Operators

Most of the operators available in pre-8.1 are available in 8.1. However, some are obsolete and have changed.

Obsolete Operators

The following table list the operators that are obsolete in 8.1. The column entitled "How to Migrate" tells you how to migrate and where to look for more information:

Operator	Equivalent	Status	How to Migrate
EXECUTE	@	Obsolete	Call the function in SELECT statement. See "PL/SQL Operator" in Chapter 6.
First/Next	#	Obsolete	Replace result-set selectivity with cursor query. See "Max and First/Next Operators" in Chapter 6.
Max	:	Obsolete	Replace result-set selectivity with cursor query. See "Max and First/Next Operators" in Chapter 6

Changed Operators

The following operator has changed in 8.1

Operator	Equivalent	Status	Migration Notes
ACCUMulate	,	Changed	Scoring method different. See Oracle8i interMedia Text Reference

New Operators

Oracle 8i interMedia Text 8.1 provides the following new operators:

• ABOUT

• TR

• TRSYN

  See Also: For more information on the ABOUT operator, see "Theme Query (English Only)" in Chapter 6. For complete syntax information about these and existing operators, see Oracle8i interMedia Text Reference