Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Related Documents
  • Conventions
• Oracle Text SQL Statements and Operators
  • ALTER INDEX
  • ALTER TABLE: Supported Partitioning Statements
  • CATSEARCH
  • CONTAINS
  • CREATE INDEX
  • CREATE SEARCH INDEX
  • CREATE HYBRID VECTOR INDEX
  • DROP INDEX
  • MATCHES
  • MATCH_SCORE
  • SCORE
• Oracle Text Indexing Elements
  • Overview
  • Creating Preferences
  • Datastore Types
    • DIRECT_DATASTORE
    • MULTI_COLUMN_DATASTORE
      • MULTI_COLUMN_DATASTORE Attributes
      • Indexing and DML
      • MULTI_COLUMN_DATASTORE Restriction
      • MULTI_COLUMN_DATASTORE Example
      • MULTI_COLUMN_DATASTORE Filter Example
      • Tagging Behavior
      • Indexing Columns as Sections
    • DETAIL_DATASTORE
      • DETAIL_DATASTORE Attributes
      • Synchronizing Primary/Detail Indexes
      • Example Primary/Detail Tables
        • Primary Table Example
        • Detail Table Example
        • Detail Table Example Attributes
        • Primary/Detail Index Example
    • FILE_DATASTORE
      • FILE_DATASTORE Attributes
      • FILE_DATASTORE and Security
      • FILE_DATASTORE Example
    • DIRECTORY_DATASTORE
      • DIRECTORY_DATASTORE Attributes
      • DIRECTORY_DATASTORE Example
    • URL_DATASTORE
      • URL_DATASTORE URL Syntax
      • URL_DATASTORE Attributes
      • URL_DATASTORE and Security
      • URL_DATASTORE Example
    • NETWORK_DATASTORE
      • NETWORK_DATASTORE URL Syntax
      • NETWORK_DATASTORE Attributes
      • NETWORK_DATASTORE Example
    • USER_DATASTORE
      • USER_DATASTORE Attributes
      • USER_DATASTORE Constraints
      • USER_DATASTORE Editing Procedure after Indexing
      • USER_DATASTORE with CLOB Example
      • USER_DATASTORE with BLOB_LOC Example
    • NESTED_DATASTORE
      • NESTED_DATASTORE Attributes
      • NESTED_DATASTORE Example
        • Create the Nested Table
        • Insert Values into Nested Table
        • Create Nested Table Preferences
        • Create Index on Nested Table
        • Query Nested Datastore
  • Filter Types
    • AUTO_FILTER
      • AUTO_FILTER Attributes
      • AUTO_FILTER and Indexing Formatted Documents
      • AUTO_FILTER and Explicitly Bypassing Plain Text or HTML in Mixed Format Columns
      • AUTO_FILTER and Character Set Conversion With AUTO_FILTER
    • NULL_FILTER
    • MAIL_FILTER
      • MAIL_FILTER Attributes
      • MAIL_FILTER Behavior
      • About the Mail Filter Configuration File
      • Mail_Filter Example
    • USER_FILTER
      • USER_FILTER Attributes
      • Using USER_FILTER with Charset and Format Columns
      • USER_FILTER and Explicitly Bypassing Plain Text or HTML in Mixed Format Columns
      • Character Set Conversion with USER_FILTER
      • User Filter Example
    • PROCEDURE_FILTER
      • PROCEDURE_FILTER Attributes
      • PROCEDURE_FILTER Parameter Order
      • PROCEDURE_FILTER Execute Requirements
      • PROCEDURE_FILTER Error Handling
      • PROCEDURE_FILTER Preference Example
  • Lexer Types
    • AUTO_LEXER
      • AUTO_LEXER Language Support
      • AUTO_LEXER Attributes Inherited from BASIC_LEXER
      • AUTO_LEXER Language-Independent Attributes
      • AUTO_LEXER Language-Dependent Attributes
      • AUTO_LEXER Dictionary Attribute
    • BASIC_LEXER
      • BASIC_LEXER Language Support
      • BASIC_LEXER Attributes
      • Stemming User-Dictionaries
      • BASIC_LEXER Example
    • MULTI_LEXER
      • MULTI_LEXER Restriction
      • MULTI_LEXER Multi-language Stoplists
      • MULTI_LEXER Example
      • MULTI_LEXER and Querying Multi-Language Tables
    • CHINESE_VGRAM_LEXER
    • CHINESE_LEXER
    • JAPANESE_VGRAM_LEXER
    • JAPANESE_LEXER
    • KOREAN_MORPH_LEXER
      • KOREAN_MORPH_ LEXER Dictionaries
      • KOREAN_MORPH_ LEXER Unicode Support
      • KOREAN_MORPH_LEXER Attributes
      • KOREAN_MORPH_ LEXER Limitations
      • KOREAN_MORPH_LEXER Example: Setting Composite Attribute
    • USER_LEXER
      • USER_LEXER Routines
      • USER_LEXER Limitations
      • USER_LEXER Attributes
      • INDEX_PROCEDURE
      • INPUT_TYPE
        • VARCHAR2 Interface
        • CLOB Interface
      • QUERY_PROCEDURE
      • Encoding Tokens as XML
      • XML Schema for No-Location, User-defined Indexing Procedure
      • XML Schema for User-defined Indexing Procedure with Location
      • XML Schema for User-defined Lexer Query Procedure
    • WORLD_LEXER
  • Wordlist Type
    • BASIC_WORDLIST
    • BASIC_WORDLIST Example
      • Enabling Fuzzy Matching and Stemming
      • Enabling Sub-string and Prefix Indexing
      • Setting Wildcard Expansion Limit
  • Storage Types
    • BASIC_STORAGE
      • BASIC_STORAGE Attributes
      • BASIC_STORAGE Default Behavior
      • BASIC_STORAGE Examples
  • Section Group Types
    • Section Group Types for Creating a Section Group
    • Section Group Examples for HTML, XML, and JSON Enabled Documents
      • Creating Section Groups in HTML Documents
      • Creating Sections Groups in XML Documents
      • Automatic Sectioning in XML Documents
      • Creating JSON Section Groups for JSON Search Index
      • Using JSON Search Index with JSON_TEXTCONTAINS
      • Using JSON Search Index with JSON_EXISTS
  • Classifier Types
    • RULE_CLASSIFIER
    • SVM_CLASSIFIER
    • SENTIMENT_CLASSIFIER
  • Cluster Types
    • KMEAN_CLUSTERING
  • Stoplists
    • Multi-Language Stoplists
    • Creating Stoplists
    • Supplied Stoplists
    • Modifying the Default Stoplist
  • System-Defined Preferences
    • Data Storage Preferences
    • Filter Preferences
    • Lexer Preferences
      • CTXSYS.DEFAULT_LEXER
      • CTXSYS.DEFAULT_EXTRACT_LEXER
      • CTXSYS.BASIC_LEXER
    • Section Group Preferences
    • Stoplist Preferences
    • Storage Preferences
    • Wordlist Preferences
  • System Parameters
    • General System Parameters
    • Default Index Parameters
      • CONTEXT Index Parameters
      • CTXCAT Index Parameters
      • CTXRULE Index Parameters
    • Default Policy Parameters
  • Token Limitations for Oracle Text Indexes
  • Auditing Oracle Text DR$ Index Tables
    • About Auditing Oracle Text DR$ Index Tables
    • Configuring an Oracle Text DR$ Index Tables Audit Policy
    • Example: Auditing Update Actions on an Oracle Text DR$ Index Table
    • How Oracle Text DR$ Index Table Entries Appear in the Audit Trail
• Oracle Text CONTAINS Query Operators
  • Operator Precedence
    • Group 1 Operators
    • Group 2 Operators and Characters
    • Procedural Operators
    • Precedence Examples
    • Altering Precedence
  • ABOUT
  • ACCUMulate ( , )
  • AND (&)
  • Broader Term (BT, BTG, BTP, BTI)
  • CTXFILTERCACHE
  • DEFINEMERGE
  • DEFINESCORE
  • EQUIValence (=)
  • Fuzzy
  • HASPATH
  • INPATH
  • MDATA
  • MINUS (-)
  • MNOT
  • Narrower Term (NT, NTG, NTP, NTI)
  • NDATA
  • NEAR (;)
  • NEAR2
  • NOT (~)
  • OR ()
  • Preferred Term (PT)
  • Related Term (RT)
  • SDATA
  • soundex (!)
  • stem ($)
  • Stored Query Expression (SQE)
  • SYNonym (SYN)
  • threshold (>)
  • Translation Term (TR)
  • Translation Term Synonym (TRSYN)
  • Top Term (TT)
  • weight (*)
  • wildcards (% _)
  • WITHIN
  • Supported Oracle Text CONTAINS Query Operators for In-Memory Full Text Search
• Special Characters in Oracle Text Queries
  • Grouping Characters
  • Escape Characters
  • Reserved Words and Characters
• CTX_ADM Package
  • About CTX_ADM Package Procedures
  • MARK_FAILED
  • RECOVER
  • RESET_AUTO_OPTIMIZE_STATUS
  • SET_PARAMETER
• CTX_ANL Package
  • About CTX_ANL Package Procedures
  • ADD_DICTIONARY
  • DROP_DICTIONARY
• CTX_CLS Package
  • About CTX_CLS Package Procedures
  • TRAIN
  • CLUSTERING
  • SA_TRAIN_MODEL
  • SA_DROP_MODEL
• CTX_DDL Package
  • ADD_ATTR_SECTION
  • ADD_AUTO_OPTIMIZE
  • ADD_FIELD_SECTION
  • ADD_INDEX
  • ADD_MDATA
  • ADD_MDATA_COLUMN
  • ADD_MDATA_SECTION
  • ADD_NDATA_SECTION
  • ADD_PATH
  • ADD_SDATA_COLUMN
  • ADD_SDATA_SECTION
  • ADD_SEC_GRP_ATTR_VAL
  • ADD_SPECIAL_SECTION
  • ADD_STOPCLASS
  • ADD_STOP_SECTION
  • ADD_STOPTHEME
  • ADD_STOPWORD
  • ADD_SUB_LEXER
  • ADD_ZONE_SECTION
  • COPY_POLICY
  • CREATE_INDEX_SET
  • CREATE_PATH_LIST
  • CREATE_POLICY
  • CREATE_PREFERENCE
  • CREATE_SECTION_GROUP
  • CREATE_SHADOW_INDEX
  • CREATE_STOPLIST
  • DROP_INDEX_SET
  • DROP_PATH_LIST
  • DROP_POLICY
  • DROP_PREFERENCE
  • DROP_SECTION_GROUP
  • DROP_SHADOW_INDEX
  • DROP_STOPLIST
  • EXCHANGE_SHADOW_INDEX
  • LOAD_STOPLIST
  • OPTIMIZE_INDEX
  • POPULATE_PENDING
  • PREFERENCE_IMPLICIT_COMMIT
  • RECREATE_INDEX_ONLINE
  • REM_SEC_GRP_ATTR_VAL
  • REMOVE_AUTO_OPTIMIZE
  • REMOVE_INDEX
  • REMOVE_MDATA
  • REMOVE_SECTION
  • REMOVE_STOPCLASS
  • REMOVE_STOPTHEME
  • REMOVE_STOPWORD
  • REMOVE_SUB_LEXER
  • REPLACE_INDEX_METADATA
  • SET_ATTRIBUTE
  • SET_SEC_GRP_ATTR
  • SET_SECTION_ATTRIBUTE
  • SYNC_INDEX
  • UNSET_ATTRIBUTE
  • UNSET_SEC_GRP_ATTR
  • UPDATE_SUB_LEXER
  • UPDATE_POLICY
  • UPDATE_SDATA
• CTX_DOC Package
  • About CTX_DOC Package Procedures
  • FILTER
  • GIST
  • HIGHLIGHT
  • IFILTER
  • MARKUP
  • PKENCODE
  • POLICY_FILTER
  • POLICY_GIST
  • POLICY_HIGHLIGHT
  • POLICY_LANGUAGES
  • POLICY_MARKUP
  • POLICY_NOUN_PHRASES
  • POLICY_PART_OF_SPEECH
  • POLICY_SNIPPET
  • POLICY_STEMS
  • POLICY_THEMES
  • POLICY_TOKENS
  • SENTIMENT
  • SENTIMENT_AGGREGATE
  • SET_KEY_TYPE
  • SNIPPET
  • THEMES
  • TOKENS
• CTX_ENTITY Package
  • ADD_EXTRACT_RULE
  • ADD_STOP_ENTITY
  • COMPILE
  • CREATE_EXTRACT_POLICY
  • DROP_EXTRACT_POLICY
  • EXTRACT
  • IMPORT_DICTIONARY
  • REMOVE_EXTRACT_RULE
  • REMOVE_STOP_ENTITY
• CTX_OUTPUT Package
  • ADD_EVENT
  • ADD_TRACE
  • DISABLE_QUERY_STATS
  • ENABLE_QUERY_STATS
  • END_LOG
  • END_QUERY_LOG
  • GET_TRACE_VALUE
  • LOG_TRACES
  • LOGFILENAME
  • REMOVE_EVENT
  • REMOVE_TRACE
  • RESET_TRACE
  • START_LOG
  • START_QUERY_LOG
• CTX_QUERY Package
  • BROWSE_WORDS
  • COUNT_HITS
  • EXPLAIN
  • HFEEDBACK
  • REMOVE_SQE
  • RESULT_SET
  • RESULT_SET_CLOB_QUERY
  • RESULT_SET_DOCUMENT
  • STORE_SQE
  • WARM_CACHE
• CTX_REPORT Package
  • Description of Procedures in CTX_REPORT
  • Using the Function Versions
  • DESCRIBE_INDEX
  • DESCRIBE_POLICY
  • CREATE_INDEX_SCRIPT
  • CREATE_POLICY_SCRIPT
  • INDEX_SIZE
  • INDEX_STATS
  • QUERY_LOG_SUMMARY
  • SHOW_TOKENS
  • TOKEN_INFO
  • TOKEN_TYPE
  • VALIDATE_INDEX
  • WILDCARD_INDEX_FRAGMENTATION
• CTX_THES Package
  • ALTER_PHRASE
  • ALTER_THESAURUS
  • BT
  • BTG
  • BTI
  • BTP
  • CREATE_PHRASE
  • CREATE_RELATION
  • CREATE_THESAURUS
  • CREATE_TRANSLATION
  • DROP_PHRASE
  • DROP_RELATION
  • DROP_THESAURUS
  • DROP_TRANSLATION
  • EXPORT_THESAURUS
  • HAS_RELATION
  • IMPORT_THESAURUS
  • NT
  • NTG
  • NTI
  • NTP
  • OUTPUT_STYLE
  • PT
  • RT
  • SN
  • SYN
  • THES_TT
  • TR
  • TRSYN
  • TT
  • UPDATE_TRANSLATION
• CTX_ULEXER Package
  • WILDCARD_TAB
• DBMS_SEARCH Package
  • CREATE_INDEX
  • AUTOCOMPLETE
    • CREATE_AUTOCOMPLETE_INDEX
    • AUTOCOMPLETE
    • DROP_AUTOCOMPLETE_INDEX
  • ADD_SOURCE
  • REMOVE_SOURCE
  • DROP_INDEX
  • GET_DOCUMENT
  • FIND
• Oracle Text Utilities
  • Thesaurus Loader (ctxload)
    • ctxload Text Loading
    • ctxload Syntax
    • ctxload Examples
  • Entity Extraction User Dictionary Loader (ctxload)
    • ctxload Syntax
    • Considerations When Creating a User Dictionary
    • XML Schema
    • ctxload Example
  • Knowledge Base Extension Compiler (ctxkbtc)
    • Knowledge Base Character Set
    • ctxkbtc Syntax
    • ctxkbtc Usage Notes
    • ctxkbtc Limitations
    • ctxkbtc Constraints on Thesaurus Terms
    • ctxkbtc Constraints on Thesaurus Relations
    • Extending the Knowledge Base
    • Example for Extending the Knowledge Base
    • Adding a Language-Specific Knowledge Base
    • Limitations for Adding a Knowledge Base
    • Order of Precedence for Multiple Thesauri
    • Size Limits for Extended Knowledge Base
  • Lexical Compiler (ctxlc)
    • Syntax of ctxlc
    • ctxlc Performance Considerations
    • ctxlc Usage Notes
    • ctxlc Example
• Oracle Text Alternative Spelling
  • Overview of Alternative Spelling Features
    • Alternate Spelling
    • Base-Letter Conversion
    • New German Spelling
  • Overriding Alternative Spelling Features
  • Alternative Spelling Conventions
    • German Alternate Spelling Conventions
    • Danish Alternate Spelling Conventions
    • Swedish Alternate Spelling Conventions
• Oracle Text Result Tables
  • CTX_QUERY Result Tables
    • EXPLAIN Table
      • EXPLAIN Table Structure
      • EXPLAIN Table Operation Column Values
      • EXPLAIN Table OPTIONS Column Values
    • HFEEDBACK Table
      • HFEEDBACK Table Structure
      • HFEEDBACK Table Operation Column Values
      • HFEEDBACK Table OPTIONS Column Values
      • CTX_FEEDBACK_TYPE
  • CTX_DOC Result Tables
    • Filter Table
    • Gist Table
    • Highlight Table
    • Markup Table
    • Theme Table
    • Token Table
  • CTX_THES Result Tables and Data Types
    • EXP_TAB Table Type
• Oracle Text Supported Document Formats
  • About Document Filtering Technology
    • Latest Updates for Patch Releases
    • Restrictions on Format Support
    • Supported Platforms for AUTO_FILTER Technology
    • Filtering on PDF Documents and Security Settings
    • PDF Filtering Limitations
    • Environment Variables
    • General Limitations
  • Supported Document Formats
    • Archive File Format
    • Database Formats
    • E-Book Formats
    • Email Formats
    • Graphic Formats (Raster and Vector Image)
    • Multimedia Formats
    • Other Formats
    • Presentation Formats
    • Spreadsheet Formats
    • Text and Markup Formats
    • Word Processing and Desktop Publishing Formats
• Text Loading Examples for Oracle Text
  • SQL INSERT Example
  • SQL*Loader Example
    • Creating the Table
    • Issuing the SQL*Loader Command
      • Example Control File: loader1.dat
      • Example Data File: loader2.dat
  • Structure of ctxload Thesaurus Import File
    • Import File Format
    • Alternate Hierarchy Structure
    • Usage Notes for Terms in Import Files
    • Usage Notes for Relationships in Import Files
    • Examples of Import Files
      • Example 1 (Flat Structure)
      • Example 2 (Hierarchical)
      • Example 3
• Oracle Text Multilingual Features
  • Introduction
  • Indexing
    • Multilingual Features for Text Index Types
      • CONTEXT Index Type
      • CTXCAT Index Type
      • CTXRULE Index Type
    • Lexer Types
    • Basic Lexer Features
      • Theme Indexing
      • Alternate Spelling
      • Base Letter Conversion
      • Composite
      • Index Stems
    • Multi Lexer Features
    • World Lexer Features
  • Querying
  • Supplied Stoplists
  • Knowledge Base
  • Multilingual Features Matrix
• The Oracle Text Scoring Algorithm
  • Scoring Algorithm for Word Queries
  • Word Scoring Example
  • DML and Scoring Algorithm
• Oracle Text Views
  • CTX_ALEXER_DICTS
  • CTX_AUTO_OPTIMIZE_INDEXES
  • CTX_AUTO_OPTIMIZE_STATUS
  • CTX_AUTOSYNC_JOBS
  • CTX_AUTOSYNC_STATUS
  • CTX_BACKGROUND_EVENTS
  • CTX_CLASSES
  • CTX_FILTER_BY_COLUMNS
  • CTX_FILTER_CACHE_STATISTICS
  • CTX_INDEXES
  • CTX_INDEX_ERRORS
  • CTX_INDEX_OBJECTS
  • CTX_INDEX_PARTITIONS
  • CTX_INDEX_PATHS
  • CTX_INDEX_SETS
  • CTX_INDEX_SET_INDEXES
  • CTX_INDEX_SUB_LEXERS
  • CTX_INDEX_SUB_LEXER_VALUES
  • CTX_INDEX_VALUES
  • CTX_OBJECTS
  • CTX_OBJECT_ATTRIBUTES
  • CTX_OBJECT_ATTRIBUTE_LOV
  • CTX_ORDER_BY_COLUMNS
  • CTX_PARAMETERS
  • CTX_PREFERENCES
  • CTX_PREFERENCE_VALUES
  • CTX_SECTIONS
  • CTX_SECTION_GROUPS
  • CTX_SQES
  • CTX_STOPLISTS
  • CTX_STOPWORDS
  • CTX_SUB_LEXERS
  • CTX_THESAURI
  • CTX_THES_PHRASES
  • CTX_TRACE_VALUES
  • CTX_USER_ALEXER_DICTS
  • CTX_USER_AUTO_OPTIMIZE_INDEXES
  • CTX_USER_AUTOSYNC_JOBS
  • CTX_USER_AUTOSYNC_STATUS
  • CTX_USER_BACKGROUND_EVENTS
  • CTX_USER_EXTRACT_POLICIES
  • CTX_USER_EXTRACT_POLICY_VALUES
  • CTX_USER_EXTRACT_RULES
  • CTX_USER_EXTRACT_STOP_ENTITIES
  • CTX_USER_EXTRACT_TYPE
  • CTX_USER_ FILTER_BY_COLUMNS
  • CTX_USER_INDEXES
  • CTX_USER_INDEX_ERRORS
  • CTX_USER_INDEX_OBJECTS
  • CTX_USER_INDEX_PARTITIONS
  • CTX_USER_INDEX_PATHS
  • CTX_USER_INDEX_SETS
  • CTX_USER_INDEX_SET_INDEXES
  • CTX_USER_INDEX_SUB_LEXERS
  • CTX_USER_INDEX_SUB_LEXER_VALS
  • CTX_USER_INDEX_VALUES
  • CTX_USER_ORDER_BY_COLUMNS
  • CTX_USER_PREFERENCES
  • CTX_USER_PREFERENCE_VALUES
  • CTX_USER_SECTIONS
  • CTX_USER_SECTION_GROUPS
  • CTX_USER_SESSION_SQES
  • CTX_USER_SQES
  • CTX_USER_STOPLISTS
  • CTX_USER_STOPWORDS
  • CTX_USER_SUB_LEXERS
  • CTX_USER_THESAURI
  • CTX_USER_THES_PHRASES
  • CTX_VERSION
  • ALL_DBMS_SEARCH_INDEXES
  • ALL_DBMS_SEARCH_INDEX_SOURCES
  • USER_DBMS_SEARCH_INDEXES
  • USER_DBMS_SEARCH_INDEX_SOURCES
• Stopword Transformations in Oracle Text
  • Understanding Stopword Transformations
  • About Stopwords in Phrase Queries
  • Word Transformations
  • AND Transformations
  • OR Transformations
  • ACCUMulate Transformations
  • MINUS Transformations
  • MNOT Transformations
  • NOT Transformations
  • EQUIValence Transformations
  • NEAR Transformations
  • Weight Transformations
  • Threshold Transformations
  • WITHIN Transformations