Oracle Text SQL Statements and Operators

These are the SQL statements and Oracle Text operators for creating and managing Oracle Text indexes and performing Oracle Text queries.

• ALTER INDEX

• ALTER TABLE: Supported Partitioning Statements

• CATSEARCH

• CONTAINS

• CREATE INDEX

• CREATE HYBRID VECTOR INDEX

• CREATE SEARCH INDEX

• DROP INDEX

• MATCHES

• MATCH_SCORE

• SCORE

Note: Starting with Oracle Database 26ai, you can also use the DBMS_SEARCH PL/SQL package to create, manage, or query search indexes for a textual and range-based ubiquitous search. Starting with Oracle Database 26ai (23.9) release, DBMS_SEARCH PL/SQL package also supports creating, managing, or querying search indexes for hybrid text-vector search. See DBMS_SEARCH Package.