SQL

Changes

The CONTAINS and SCORE operators remain unchanged for 8.1.

See Also: For more information about migrating Text queries, see Chapter 6, "Querying". For the syntax of these operators, see Oracle8i interMedia Text Reference

New SQL Commands

You use following standard SQL commands to create and manage the 8.1 Text index, which is a domain index of type context:

• Use CREATE INDEX to create a Text index.

• Use ALTER INDEX for managing Text indexes.

• Use DROP INDEX to drop a Text index.

  See Also: For more information about migrating Text indexes with CREATE INDEX and ALTER INDEX, see Chapter 5, "Indexing". For syntax information, refer to the Oracle8i interMedia Text Reference.

  .