List of Tables
Title and Copyright Information
Preface
- Audience
- Documentation Accessibility
- Related Documents
- Conventions
Changes in This Release for Oracle Text Reference
- Changes in Oracle Text 12c Release 2 (12.2.0.1)
1 Oracle Text SQL Statements and Operators
- 1.1 ALTER INDEX
- 1.2 ALTER TABLE: Supported Partitioning Statements
- 1.3 CATSEARCH
- 1.4 CONTAINS
- 1.5 CREATE INDEX
- 1.6 CREATE SEARCH INDEX
- 1.7 DROP INDEX
- 1.8 MATCHES
- 1.9 MATCH_SCORE
- 1.10 SCORE
2 Oracle Text Indexing Elements
- 2.1 Overview
- 2.2 Creating Preferences
- 2.3 Datastore Types
- 2.4 Filter Types
- 2.5 Lexer Types
- 2.6 Wordlist Type
  - 2.6.1 BASIC_WORDLIST
  - 2.6.2 BASIC_WORDLIST Example
- 2.7 Storage Types
  - 2.7.1 BASIC_STORAGE
- 2.8 Section Group Types
  - 2.8.1 Section Group Types for Creating a Section Group
  - 2.8.2 Section Group Examples for HTML, XML, and JSON Enabled Documents
- 2.9 Classifier Types
- 2.10 Cluster Types
  - 2.10.1 KMEAN_CLUSTERING
- 2.11 Stoplists
- 2.12 System-Defined Preferences
- 2.13 System Parameters
- 2.14 Token Limitations
3 Oracle Text CONTAINS Query Operators
- 3.1 Operator Precedence
  - 3.1.1 Group 1 Operators
  - 3.1.2 Group 2 Operators and Characters
  - 3.1.3 Procedural Operators
  - 3.1.4 Precedence Examples
  - 3.1.5 Altering Precedence
- 3.2 ABOUT
- 3.3 ACCUMulate ( , )
- 3.4 AND (&)
- 3.5 Broader Term (BT, BTG, BTP, BTI)
- 3.6 CTXFILTERCACHE
- 3.7 DEFINEMERGE
- 3.8 DEFINESCORE
- 3.9 EQUIValence (=)
- 3.10 Fuzzy
- 3.11 HASPATH
- 3.12 INPATH
- 3.13 MDATA
- 3.14 MINUS (-)
- 3.15 MNOT
- 3.16 Narrower Term (NT, NTG, NTP, NTI)
- 3.17 NDATA
- 3.18 NEAR (;)
- 3.19 NEAR2
- 3.20 NOT (~)
- 3.21 OR (|)
- 3.22 Preferred Term (PT)
- 3.23 Related Term (RT)
- 3.24 SDATA
- 3.25 soundex (!)
- 3.26 stem ($)
- 3.27 Stored Query Expression (SQE)
- 3.28 SYNonym (SYN)
- 3.29 threshold (>)
- 3.30 Translation Term (TR)
- 3.31 Translation Term Synonym (TRSYN)
- 3.32 Top Term (TT)
- 3.33 weight (*)
- 3.34 wildcards (% _)
- 3.35 WITHIN
4 Special Characters in Oracle Text Queries
- 4.1 Grouping Characters
- 4.2 Escape Characters
- 4.3 Reserved Words and Characters
5 CTX_ADM Package
- 5.1 About CTX_ADM Package Procedures
- 5.2 MARK_FAILED
- 5.3 RECOVER
- 5.4 RESET_AUTO_OPTIMIZE_STATUS
- 5.5 SET_PARAMETER
6 CTX_ANL Package
- 6.1 About CTX_ANL Package Procedures
- 6.2 ADD_DICTIONARY
- 6.3 DROP_DICTIONARY
7 CTX_CLS Package
- 7.1 About CTX_CLS Package Procedures
- 7.2 TRAIN
- 7.3 CLUSTERING
- 7.4 SA_TRAIN_MODEL
- 7.5 SA_DROP_MODEL
8 CTX_DDL Package
- 8.1 ADD_ATTR_SECTION
- 8.2 ADD_AUTO_OPTIMIZE
- 8.3 ADD_FIELD_SECTION
- 8.4 ADD_INDEX
- 8.5 ADD_MDATA
- 8.6 ADD_MDATA_COLUMN
- 8.7 ADD_MDATA_SECTION
- 8.8 ADD_NDATA_SECTION
- 8.9 ADD_SDATA_COLUMN
- 8.10 ADD_SDATA_SECTION
- 8.11 ADD_SEC_GRP_ATTR_VAL
- 8.12 ADD_SPECIAL_SECTION
- 8.13 ADD_STOPCLASS
- 8.14 ADD_STOP_SECTION
- 8.15 ADD_STOPTHEME
- 8.16 ADD_STOPWORD
- 8.17 ADD_SUB_LEXER
- 8.18 ADD_ZONE_SECTION
- 8.19 COPY_POLICY
- 8.20 CREATE_INDEX_SET
- 8.21 CREATE_POLICY
- 8.22 CREATE_PREFERENCE
- 8.23 CREATE_SECTION_GROUP
- 8.24 CREATE_SHADOW_INDEX
- 8.25 CREATE_STOPLIST
- 8.26 DROP_INDEX_SET
- 8.27 DROP_POLICY
- 8.28 DROP_PREFERENCE
- 8.29 DROP_SECTION_GROUP
- 8.30 DROP_SHADOW_INDEX
- 8.31 DROP_STOPLIST
- 8.32 EXCHANGE_SHADOW_INDEX
- 8.33 OPTIMIZE_INDEX
- 8.34 POPULATE_PENDING
- 8.35 PREFERENCE_IMPLICIT_COMMIT
- 8.36 RECREATE_INDEX_ONLINE
- 8.37 REM_SEC_GRP_ATTR_VAL
- 8.38 REMOVE_AUTO_OPTIMIZE
- 8.39 REMOVE_INDEX
- 8.40 REMOVE_MDATA
- 8.41 REMOVE_SECTION
- 8.42 REMOVE_STOPCLASS
- 8.43 REMOVE_STOPTHEME
- 8.44 REMOVE_STOPWORD
- 8.45 REMOVE_SUB_LEXER
- 8.46 REPLACE_INDEX_METADATA
- 8.47 SET_ATTRIBUTE
- 8.48 SET_SEC_GRP_ATTR
- 8.49 SET_SECTION_ATTRIBUTE
- 8.50 SYNC_INDEX
- 8.51 UNSET_ATTRIBUTE
- 8.52 UNSET_SEC_GRP_ATTR
- 8.53 UPDATE_SUB_LEXER
- 8.54 UPDATE_POLICY
- 8.55 UPDATE_SDATA
9 CTX_DOC Package
- 9.1 About CTX_DOC Package Procedures
- 9.2 FILTER
- 9.3 GIST
- 9.4 HIGHLIGHT
- 9.5 IFILTER
- 9.6 MARKUP
- 9.7 PKENCODE
- 9.8 POLICY_FILTER
- 9.9 POLICY_GIST
- 9.10 POLICY_HIGHLIGHT
- 9.11 POLICY_LANGUAGES
- 9.12 POLICY_MARKUP
- 9.13 POLICY_NOUN_PHRASES
- 9.14 POLICY_PART_OF_SPEECH
- 9.15 POLICY_SNIPPET
- 9.16 POLICY_STEMS
- 9.17 POLICY_THEMES
- 9.18 POLICY_TOKENS
- 9.19 SENTIMENT
- 9.20 SENTIMENT_AGGREGATE
- 9.21 SET_KEY_TYPE
- 9.22 SNIPPET
- 9.23 THEMES
- 9.24 TOKENS
10 CTX_ENTITY Package
- 10.1 ADD_EXTRACT_RULE
- 10.2 ADD_STOP_ENTITY
- 10.3 COMPILE
- 10.4 CREATE_EXTRACT_POLICY
- 10.5 DROP_EXTRACT_POLICY
- 10.6 EXTRACT
- 10.7 REMOVE_EXTRACT_RULE
- 10.8 REMOVE_STOP_ENTITY
11 CTX_OUTPUT Package
- 11.1 ADD_EVENT
- 11.2 ADD_TRACE
- 11.3 DISABLE_QUERY_STATS
- 11.4 ENABLE_QUERY_STATS
- 11.5 END_LOG
- 11.6 END_QUERY_LOG
- 11.7 GET_TRACE_VALUE
- 11.8 LOG_TRACES
- 11.9 LOGFILENAME
- 11.10 REMOVE_EVENT
- 11.11 REMOVE_TRACE
- 11.12 RESET_TRACE
- 11.13 START_LOG
- 11.14 START_QUERY_LOG
12 CTX_QUERY Package
- 12.1 BROWSE_WORDS
- 12.2 COUNT_HITS
- 12.3 EXPLAIN
- 12.4 HFEEDBACK
- 12.5 REMOVE_SQE
- 12.6 RESULT_SET
- 12.7 RESULT_SET_CLOB_QUERY
- 12.8 RESULT_SET_DOCUMENT
- 12.9 STORE_SQE
13 CTX_REPORT Package
- 13.1 Description of Procedures in CTX_REPORT
- 13.2 Using the Function Versions
- 13.3 DESCRIBE_INDEX
- 13.4 DESCRIBE_POLICY
- 13.5 CREATE_INDEX_SCRIPT
- 13.6 CREATE_POLICY_SCRIPT
- 13.7 INDEX_SIZE
- 13.8 INDEX_STATS
- 13.9 QUERY_LOG_SUMMARY
- 13.10 TOKEN_INFO
- 13.11 TOKEN_TYPE
- 13.12 VALIDATE_INDEX
14 CTX_THES Package
- 14.1 ALTER_PHRASE
- 14.2 ALTER_THESAURUS
- 14.3 BT
- 14.4 BTG
- 14.5 BTI
- 14.6 BTP
- 14.7 CREATE_PHRASE
- 14.8 CREATE_RELATION
- 14.9 CREATE_THESAURUS
- 14.10 CREATE_TRANSLATION
- 14.11 DROP_PHRASE
- 14.12 DROP_RELATION
- 14.13 DROP_THESAURUS
- 14.14 DROP_TRANSLATION
- 14.15 EXPORT_THESAURUS
- 14.16 HAS_RELATION
- 14.17 IMPORT_THESAURUS
- 14.18 NT
- 14.19 NTG
- 14.20 NTI
- 14.21 NTP
- 14.22 OUTPUT_STYLE
- 14.23 PT
- 14.24 RT
- 14.25 SN
- 14.26 SYN
- 14.27 THES_TT
- 14.28 TR
- 14.29 TRSYN
- 14.30 TT
- 14.31 UPDATE_TRANSLATION
15 CTX_ULEXER Package
- 15.1 WILDCARD_TAB
16 Oracle Text Utilities
- 16.1 Thesaurus Loader (ctxload)
- 16.2 Entity Extraction User Dictionary Loader (ctxload)
- 16.3 Knowledge Base Extension Compiler (ctxkbtc)
- 16.4 Lexical Compiler (ctxlc)
17 Oracle Text Alternative Spelling
- 17.1 Overview of Alternative Spelling Features
- 17.2 Overriding Alternative Spelling Features
- 17.3 Alternative Spelling Conventions
A Oracle Text Result Tables
- A.1 CTX_QUERY Result Tables
  - A.1.1 EXPLAIN Table
  - A.1.2 HFEEDBACK Table
- A.2 CTX_DOC Result Tables
- A.3 CTX_THES Result Tables and Data Types
  - A.3.1 EXP_TAB Table Type
B Oracle Text Supported Document Formats
- B.1 About Document Filtering Technology
- B.2 Supported Document Formats
C Text Loading Examples for Oracle Text
- C.1 SQL INSERT Example
- C.2 SQL*Loader Example
  - C.2.1 Creating the Table
  - C.2.2 Issuing the SQL*Loader Command
    - C.2.2.1 Example Control File: loader1.dat
    - C.2.2.2 Example Data File: loader2.dat
- C.3 Structure of ctxload Thesaurus Import File
D Oracle Text Multilingual Features
- D.1 Introduction
- D.2 Indexing
- D.3 Querying
- D.4 Supplied Stop Lists
- D.5 Knowledge Base
- D.6 Multilingual Features Matrix
E Oracle Text Supplied Stoplists
- E.1 English Default Stoplist
- E.2 Chinese Stoplist (Traditional)
- E.3 Chinese Stoplist (Simplified)
- E.4 Danish (dk) Default Stoplist
- E.5 Dutch (nl) Default Stoplist
- E.6 Finnish (sf) Default Stoplist
- E.7 French (f) Default Stoplist
- E.8 German (d) Default Stoplist
- E.9 Italian (i) Default Stoplist
- E.10 Portuguese (pt) Default Stoplist
- E.11 Spanish (e) Default Stoplist
- E.12 Swedish (s) Default Stoplist
F The Oracle Text Scoring Algorithm
- F.1 Scoring Algorithm for Word Queries
- F.2 Word Scoring Example
- F.3 DML and Scoring Algorithm
G Oracle Text Views
- G.1 CTX_ALEXER_DICTS
- G.2 CTX_AUTO_OPTIMIZE_INDEXES
- G.3 CTX_AUTO_OPTIMIZE_STATUS
- G.4 CTX_CLASSES
- G.5 CTX_FILTER_BY_COLUMNS
- G.6 CTX_FILTER_CACHE_STATISTICS
- G.7 CTX_INDEXES
- G.8 CTX_INDEX_ERRORS
- G.9 CTX_INDEX_OBJECTS
- G.10 CTX_INDEX_PARTITIONS
- G.11 CTX_INDEX_SETS
- G.12 CTX_INDEX_SET_INDEXES
- G.13 CTX_INDEX_SUB_LEXERS
- G.14 CTX_INDEX_SUB_LEXER_VALUES
- G.15 CTX_INDEX_VALUES
- G.16 CTX_OBJECTS
- G.17 CTX_OBJECT_ATTRIBUTES
- G.18 CTX_OBJECT_ATTRIBUTE_LOV
- G.19 CTX_ORDER_BY_COLUMNS
- G.20 CTX_PARAMETERS
- G.21 CTX_PENDING
- G.22 CTX_PREFERENCES
- G.23 CTX_PREFERENCE_VALUES
- G.24 CTX_SECTIONS
- G.25 CTX_SECTION_GROUPS
- G.26 CTX_SQES
- G.27 CTX_STOPLISTS
- G.28 CTX_STOPWORDS
- G.29 CTX_SUB_LEXERS
- G.30 CTX_THESAURI
- G.31 CTX_THES_PHRASES
- G.32 CTX_TRACE_VALUES
- G.33 CTX_USER_ALEXER_DICTS
- G.34 CTX_USER_AUTO_OPTIMIZE_INDEXES
- G.35 CTX_USER_EXTRACT_POLICIES
- G.36 CTX_USER_EXTRACT_POLICY_VALUES
- G.37 CTX_USER_EXTRACT_RULES
- G.38 CTX_USER_EXTRACT_STOP_ENTITIES
- G.39 CTX_USER_ FILTER_BY_COLUMNS
- G.40 CTX_USER_INDEXES
- G.41 CTX_USER_INDEX_ERRORS
- G.42 CTX_USER_INDEX_OBJECTS
- G.43 CTX_USER_INDEX_PARTITIONS
- G.44 CTX_USER_INDEX_SETS
- G.45 CTX_USER_INDEX_SET_INDEXES
- G.46 CTX_USER_INDEX_SUB_LEXERS
- G.47 CTX_USER_INDEX_SUB_LEXER_VALS
- G.48 CTX_USER_INDEX_VALUES
- G.49 CTX_USER_ORDER_BY_COLUMNS
- G.50 CTX_USER_PENDING
- G.51 CTX_USER_PREFERENCES
- G.52 CTX_USER_PREFERENCE_VALUES
- G.53 CTX_USER_SECTIONS
- G.54 CTX_USER_SECTION_GROUPS
- G.55 CTX_USER_SESSION_SQES
- G.56 CTX_USER_SQES
- G.57 CTX_USER_STOPLISTS
- G.58 CTX_USER_STOPWORDS
- G.59 CTX_USER_SUB_LEXERS
- G.60 CTX_USER_THESAURI
- G.61 CTX_USER_THES_PHRASES
- G.62 CTX_VERSION
H Stopword Transformations in Oracle Text
- H.1 Understanding Stopword Transformations
- H.2 About Stopwords in Phrase Queries
- H.3 Word Transformations
- H.4 AND Transformations
- H.5 OR Transformations
- H.6 ACCUMulate Transformations
- H.7 MINUS Transformations
- H.8 MNOT Transformations
- H.9 NOT Transformations
- H.10 EQUIValence Transformations
- H.11 NEAR Transformations
- H.12 Weight Transformations
- H.13 Threshold Transformations
- H.14 WITHIN Transformations
Index