Table of Contents
- List of Tables
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Text Reference
- 1 Oracle Text SQL Statements and Operators
-
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.5.1 AUTO_LEXER
- 2.5.2 BASIC_LEXER
- 2.5.3 MULTI_LEXER
- 2.5.4 CHINESE_VGRAM_LEXER
- 2.5.5 CHINESE_LEXER
- 2.5.6 JAPANESE_VGRAM_LEXER
- 2.5.7 JAPANESE_LEXER
- 2.5.8 KOREAN_MORPH_LEXER
-
2.5.9
USER_LEXER
- 2.5.9.1 USER_LEXER Routines
- 2.5.9.2 USER_LEXER Limitations
- 2.5.9.3 USER_LEXER Attributes
- 2.5.9.4 INDEX_PROCEDURE
- 2.5.9.5 INPUT_TYPE
- 2.5.9.6 QUERY_PROCEDURE
- 2.5.9.7 Encoding Tokens as XML
- 2.5.9.8 XML Schema for No-Location, User-defined Indexing Procedure
- 2.5.9.9 XML Schema for User-defined Indexing Procedure with Location
- 2.5.9.10 XML Schema for User-defined Lexer Query Procedure
- 2.5.10 WORLD_LEXER
- 2.6 Wordlist Type
- 2.7 Storage Types
-
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.8.2.1 Creating Section Groups in HTML Documents
- 2.8.2.2 Creating Sections Groups in XML Documents
- 2.8.2.3 Automatic Sectioning in XML Documents
- 2.8.2.4 Creating JSON Section Groups for JSON Search Index
- 2.8.2.5 Using JSON Search Index with JSON_TEXTCONTAINS
- 2.8.2.6 Using JSON Search Index with JSON_EXISTS
- 2.9 Classifier Types
- 2.10 Cluster Types
- 2.11 Stoplists
- 2.12 System-Defined Preferences
- 2.13 System Parameters
- 2.14 Token Limitations for Oracle Text Indexes
-
3
Oracle Text CONTAINS Query Operators
- 3.1 Operator 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
- 5 CTX_ADM Package
- 6 CTX_ANL Package
- 7 CTX_CLS Package
-
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
- 11 CTX_OUTPUT Package
- 12 CTX_QUERY Package
- 13 CTX_REPORT Package
-
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
-
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.3.1 Knowledge Base Character Set
- 16.3.2 ctxkbtc Syntax
- 16.3.3 ctxkbtc Usage Notes
- 16.3.4 ctxkbtc Limitations
- 16.3.5 ctxkbtc Constraints on Thesaurus Terms
- 16.3.6 ctxkbtc Constraints on Thesaurus Relations
- 16.3.7 Extending the Knowledge Base
- 16.3.8 Example for Extending the Knowledge Base
- 16.3.9 Adding a Language-Specific Knowledge Base
- 16.3.10 Limitations for Adding a Knowledge Base
- 16.3.11 Order of Precedence for Multiple Thesauri
- 16.3.12 Size Limits for Extended Knowledge Base
- 16.4 Lexical Compiler (ctxlc)
- 17 Oracle Text Alternative Spelling
- A Oracle Text Result Tables
- B Oracle Text Supported Document Formats
- C Text Loading Examples for Oracle Text
- D Oracle Text Multilingual Features
-
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
-
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