Table of Contents
- Title and Copyright Information
- Preface
- 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
- 2.15 Auditing Oracle Text DR$ Index Tables
-
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
- 3.36 Supported Oracle Text CONTAINS Query Operators for In-Memory Full Text Search
- 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_PATH
- 8.10 ADD_SDATA_COLUMN
- 8.11 ADD_SDATA_SECTION
- 8.12 ADD_SEC_GRP_ATTR_VAL
- 8.13 ADD_SPECIAL_SECTION
- 8.14 ADD_STOPCLASS
- 8.15 ADD_STOP_SECTION
- 8.16 ADD_STOPTHEME
- 8.17 ADD_STOPWORD
- 8.18 ADD_SUB_LEXER
- 8.19 ADD_ZONE_SECTION
- 8.20 COPY_POLICY
- 8.21 CREATE_INDEX_SET
- 8.22 CREATE_PATH_LIST
- 8.23 CREATE_POLICY
- 8.24 CREATE_PREFERENCE
- 8.25 CREATE_SECTION_GROUP
- 8.26 CREATE_SHADOW_INDEX
- 8.27 CREATE_STOPLIST
- 8.28 DROP_INDEX_SET
- 8.29 DROP_PATH_LIST
- 8.30 DROP_POLICY
- 8.31 DROP_PREFERENCE
- 8.32 DROP_SECTION_GROUP
- 8.33 DROP_SHADOW_INDEX
- 8.34 DROP_STOPLIST
- 8.35 EXCHANGE_SHADOW_INDEX
- 8.36 LOAD_STOPLIST
- 8.37 OPTIMIZE_INDEX
- 8.38 POPULATE_PENDING
- 8.39 PREFERENCE_IMPLICIT_COMMIT
- 8.40 RECREATE_INDEX_ONLINE
- 8.41 REM_SEC_GRP_ATTR_VAL
- 8.42 REMOVE_AUTO_OPTIMIZE
- 8.43 REMOVE_INDEX
- 8.44 REMOVE_MDATA
- 8.45 REMOVE_SECTION
- 8.46 REMOVE_STOPCLASS
- 8.47 REMOVE_STOPTHEME
- 8.48 REMOVE_STOPWORD
- 8.49 REMOVE_SUB_LEXER
- 8.50 REPLACE_INDEX_METADATA
- 8.51 SET_ATTRIBUTE
- 8.52 SET_SEC_GRP_ATTR
- 8.53 SET_SECTION_ATTRIBUTE
- 8.54 SYNC_INDEX
- 8.55 UNSET_ATTRIBUTE
- 8.56 UNSET_SEC_GRP_ATTR
- 8.57 UPDATE_SUB_LEXER
- 8.58 UPDATE_POLICY
- 8.59 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 DBMS_SEARCH Package
-
17
Oracle Text Utilities
- 17.1 Thesaurus Loader (ctxload)
- 17.2 Entity Extraction User Dictionary Loader (ctxload)
-
17.3
Knowledge Base Extension Compiler (ctxkbtc)
- 17.3.1 Knowledge Base Character Set
- 17.3.2 ctxkbtc Syntax
- 17.3.3 ctxkbtc Usage Notes
- 17.3.4 ctxkbtc Limitations
- 17.3.5 ctxkbtc Constraints on Thesaurus Terms
- 17.3.6 ctxkbtc Constraints on Thesaurus Relations
- 17.3.7 Extending the Knowledge Base
- 17.3.8 Example for Extending the Knowledge Base
- 17.3.9 Adding a Language-Specific Knowledge Base
- 17.3.10 Limitations for Adding a Knowledge Base
- 17.3.11 Order of Precedence for Multiple Thesauri
- 17.3.12 Size Limits for Extended Knowledge Base
- 17.4 Lexical Compiler (ctxlc)
- 18 Oracle Text Alternative Spelling
- A Oracle Text Result Tables
-
B
Oracle Text Supported Document Formats
- B.1 About Document Filtering Technology
-
B.2
Supported Document Formats
- B.2.1 Archive File Format
- B.2.2 Database Formats
- B.2.3 E-Book Formats
- B.2.4 Email Formats
- B.2.5 Graphic Formats (Raster and Vector Image)
- B.2.6 Multimedia Formats
- B.2.7 Other Formats
- B.2.8 Presentation Formats
- B.2.9 Spreadsheet Formats
- B.2.10 Text and Markup Formats
- B.2.11 Word Processing and Desktop Publishing Formats
- C Text Loading Examples for Oracle Text
- D Oracle Text Multilingual Features
- E The Oracle Text Scoring Algorithm
-
F
Oracle Text Views
- F.1 CTX_ALEXER_DICTS
- F.2 CTX_AUTO_OPTIMIZE_INDEXES
- F.3 CTX_AUTO_OPTIMIZE_STATUS
- F.4 CTX_AUTOSYNC_JOBS
- F.5 CTX_AUTOSYNC_STATUS
- F.6 CTX_BACKGROUND_EVENTS
- F.7 CTX_CLASSES
- F.8 CTX_FILTER_BY_COLUMNS
- F.9 CTX_FILTER_CACHE_STATISTICS
- F.10 CTX_INDEXES
- F.11 CTX_INDEX_ERRORS
- F.12 CTX_INDEX_OBJECTS
- F.13 CTX_INDEX_PARTITIONS
- F.14 CTX_INDEX_SETS
- F.15 CTX_INDEX_SET_INDEXES
- F.16 CTX_INDEX_SUB_LEXERS
- F.17 CTX_INDEX_SUB_LEXER_VALUES
- F.18 CTX_INDEX_VALUES
- F.19 CTX_OBJECTS
- F.20 CTX_OBJECT_ATTRIBUTES
- F.21 CTX_OBJECT_ATTRIBUTE_LOV
- F.22 CTX_ORDER_BY_COLUMNS
- F.23 CTX_PARAMETERS
- F.24 CTX_PREFERENCES
- F.25 CTX_PREFERENCE_VALUES
- F.26 CTX_SECTIONS
- F.27 CTX_SECTION_GROUPS
- F.28 CTX_SQES
- F.29 CTX_STOPLISTS
- F.30 CTX_STOPWORDS
- F.31 CTX_SUB_LEXERS
- F.32 CTX_THESAURI
- F.33 CTX_THES_PHRASES
- F.34 CTX_TRACE_VALUES
- F.35 CTX_USER_ALEXER_DICTS
- F.36 CTX_USER_AUTO_OPTIMIZE_INDEXES
- F.37 CTX_USER_AUTOSYNC_JOBS
- F.38 CTX_USER_AUTOSYNC_STATUS
- F.39 CTX_USER_BACKGROUND_EVENTS
- F.40 CTX_USER_EXTRACT_POLICIES
- F.41 CTX_USER_EXTRACT_POLICY_VALUES
- F.42 CTX_USER_EXTRACT_RULES
- F.43 CTX_USER_EXTRACT_STOP_ENTITIES
- F.44 CTX_USER_EXTRACT_TYPE
- F.45 CTX_USER_ FILTER_BY_COLUMNS
- F.46 CTX_USER_INDEXES
- F.47 CTX_USER_INDEX_ERRORS
- F.48 CTX_USER_INDEX_OBJECTS
- F.49 CTX_USER_INDEX_PARTITIONS
- F.50 CTX_USER_INDEX_SETS
- F.51 CTX_USER_INDEX_SET_INDEXES
- F.52 CTX_USER_INDEX_SUB_LEXERS
- F.53 CTX_USER_INDEX_SUB_LEXER_VALS
- F.54 CTX_USER_INDEX_VALUES
- F.55 CTX_USER_ORDER_BY_COLUMNS
- F.56 CTX_USER_PREFERENCES
- F.57 CTX_USER_PREFERENCE_VALUES
- F.58 CTX_USER_SECTIONS
- F.59 CTX_USER_SECTION_GROUPS
- F.60 CTX_USER_SESSION_SQES
- F.61 CTX_USER_SQES
- F.62 CTX_USER_STOPLISTS
- F.63 CTX_USER_STOPWORDS
- F.64 CTX_USER_SUB_LEXERS
- F.65 CTX_USER_THESAURI
- F.66 CTX_USER_THES_PHRASES
- F.67 CTX_VERSION
- F.68 ALL_DBMS_SEARCH_INDEXES
- F.69 ALL_DBMS_SEARCH_INDEX_SOURCES
- F.70 USER_DBMS_SEARCH_INDEXES
- F.71 USER_DBMS_SEARCH_INDEX_SOURCES
-
G
Stopword Transformations in Oracle Text
- G.1 Understanding Stopword Transformations
- G.2 About Stopwords in Phrase Queries
- G.3 Word Transformations
- G.4 AND Transformations
- G.5 OR Transformations
- G.6 ACCUMulate Transformations
- G.7 MINUS Transformations
- G.8 MNOT Transformations
- G.9 NOT Transformations
- G.10 EQUIValence Transformations
- G.11 NEAR Transformations
- G.12 Weight Transformations
- G.13 Threshold Transformations
- G.14 WITHIN Transformations