Oracle Reference -- Contents

Overview

Creating Preferences

Datastore Types

DIRECT_DATASTORE

MULTI_COLUMN_DATASTORE

Filter Types

Lexer Types

Wordlist Type

BASIC_WORDLIST Example

Storage Types

BASIC_STORAGE

Section Group Types

Section Group Examples

Classifier Types

RULE_CLASSIFIER

Stoplists

Multi-Language Stoplists

Creating Stoplists

Modifying the Default Stoplist

System-Defined Preferences

System Parameters

General System Parameters

Default Index Parameters

Operator Precedence

Group 1 Operators

Group 2 Operators and Characters

ABOUT

AND (&)

Broader Term (BT, BTG, BTP, BTI)

EQUIValence (=)

Fuzzy

HASPATH

INPATH

MINUS (-)

Narrower Term (NT, NTG, NTP, NTI)

NEAR (;)

NOT (~)

OR (|)

Preferred Term (PT)

Related Term (RT)

soundex (!)

stem ($)

Stored Query Expression (SQE)

SYNonym (SYN)

threshold (>)

Translation Term (TR)

Translation Term Synonym (TRSYN)

Top Term (TT)

weight (*)

wildcards (% _)

Right-Truncated Queries

Left- and Double-Truncated Queries

Improving Wildcard Query Performance

WITHIN

Grouping Characters

Escape Characters

Querying Escape Characters

Reserved Words and Characters

RECOVER

SET_PARAMETER

SHUTDOWN

TRAIN

ADD_ATTR_SECTION

ADD_FIELD_SECTION

ADD_INDEX

ADD_SPECIAL_SECTION

ADD_STOPCLASS

ADD_STOP_SECTION

ADD_STOPTHEME

ADD_STOPWORD

ADD_SUB_LEXER

ADD_ZONE_SECTION

CREATE_INDEX_SET

CREATE_POLICY

CREATE_PREFERENCE

CREATE_SECTION_GROUP

CREATE_STOPLIST

DROP_INDEX_SET

DROP_POLICY

DROP_PREFERENCE

DROP_SECTION_GROUP

DROP_STOPLIST

OPTIMIZE_INDEX

REMOVE_INDEX

REMOVE_SECTION

REMOVE_STOPCLASS

REMOVE_STOPTHEME

REMOVE_STOPWORD

SET_ATTRIBUTE

SYNC_INDEX

UNSET_ATTRIBUTE

UPDATE_POLICY

FILTER

GIST

HIGHLIGHT

IFILTER

MARKUP

PKENCODE

SET_KEY_TYPE

THEMES

TOKENS

ADD_EVENT

END_LOG

LOGFILENAME

REMOVE_EVENT

START_LOG

BROWSE_WORDS

COUNT_HITS

EXPLAIN

HFEEDBACK

REMOVE_SQE

STORE_SQE

Procedures in CTX_REPORT

Using the Function Versions

DESCRIBE_INDEX

DESCRIBE_POLICY

CREATE_INDEX_SCRIPT

CREATE_POLICY_SCRIPT

INDEX_SIZE

INDEX_STATS

TOKEN_INFO

TOKEN_TYPE

ALTER_PHRASE

ALTER_THESAURUS

BT

BTG

BTI

BTP

CREATE_PHRASE

CREATE_RELATION

CREATE_THESAURUS

CREATE_TRANSLATION

DROP_PHRASE

DROP_RELATION

DROP_THESAURUS

DROP_TRANSLATION

HAS_RELATION

NT

NTG

NTI

NTP

OUTPUT_STYLE

PT

RT

SN

SYN

THES_TT

TR

TRSYN

TT

UPDATE_TRANSLATION

WILDCARD_TAB

Thesaurus Loader (ctxload)

Text Loading

ctxload Syntax

ctxload Examples

Knowledge Base Extension Compiler (ctxkbtc)

ctxkbtc Syntax

ctxkbtc Usage Notes

ctxkbtc Limitations

ctxkbtc Constraints on Thesaurus Terms

ctxkbtc Constraints on Thesaurus Relations

Extending the Knowledge Base

Adding a Language-Specific Knowledge Base

Order of Precedence for Multiple Thesauri

Size Limits for Extended Knowledge Base

CTX_QUERY Result Tables

EXPLAIN Table

HFEEDBACK Table

CTX_DOC Result Tables

CTX_THES Result Tables and Data Types

EXP_TAB Table Type

About Document Filtering Technology

Supported Platforms

Environment Variables

Requirements for UNIX Platforms

OLE2 Object Support

Supported Document Formats

Word Processing - Generic

Word Processing - DOS

Word Processing - International

Word Processing - Windows

Word Processing - Macintosh

Word Processing - Unix

Standard Graphic Formats

Other

Unsupported Formats

SQL INSERT Example

SQL*Loader Example

Creating the Table

Issuing the SQL*Loader Command

Structure of ctxload Thesaurus Import File

Alternate Hierarchy Structure

Usage Notes for Terms in Import Files

Usage Notes for Relationships in Import Files

Examples of Import Files

English Default Stoplist

Chinese Stoplist (Traditional)

Chinese Stoplist (Simplified)

Danish (dk) Default Stoplist

Dutch (nl) Default Stoplist

Finnish (sf) Default Stoplist

French (f) Default Stoplist

German (d) Default Stoplist

Italian (i) Default Stoplist

Portuguese (pt) Default Stoplist

Spanish (e) Default Stoplist

Swedish (s) Default Stoplist

Overview

Enabling Alternate Spelling

Disabling Alternate Spelling

German Alternate Spelling

Danish Alternate Spelling

Swedish Alternate Spelling

Scoring Algorithm for Word Queries

Example

DML and Scoring

CTX_CLASSES

CTX_INDEXES

CTX_INDEX_ERRORS

CTX_INDEX_OBJECTS

CTX_INDEX_PARTITIONS

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_PARAMETERS

CTX_PENDING

CTX_PREFERENCES

CTX_PREFERENCE_VALUES

CTX_SECTIONS

CTX_SECTION_GROUPS

CTX_SERVERS

CTX_SQES

CTX_STOPLISTS

CTX_STOPWORDS

CTX_SUB_LEXERS

CTX_THESAURI

CTX_THES_PHRASES

CTX_USER_INDEXES

CTX_USER_INDEX_ERRORS

CTX_USER_INDEX_OBJECTS

CTX_USER_INDEX_PARTITIONS

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_PENDING

CTX_USER_PREFERENCES

CTX_USER_PREFERENCE_VALUES

CTX_USER_SECTIONS

CTX_USER_SECTION_GROUPS

CTX_USER_SQES

CTX_USER_STOPLISTS

CTX_USER_STOPWORDS

CTX_USER_SUB_LEXERS

CTX_USER_THESAURI

CTX_USER_THES_PHRASES

CTX_VERSION

Understanding Stopword Transformations

Word Transformations

AND Transformations

OR Transformations

ACCUMulate Transformations

MINUS Transformations

NOT Transformations

EQUIValence Transformations

NEAR Transformations

Weight Transformations

Threshold Transformations

WITHIN Transformations

Branch 1: science and technology

Branch 2: business and economics

Branch 3: government and military

Branch 4: social environment

Branch 5: geography

Branch 6: abstract ideas and concepts

Contents

Title and Copyright Information

Send Us Your Comments

Preface

What's New in Oracle Text?

1 SQL Statements and Operators

2 Indexing

3 CONTAINS Query Operators

4 Special Characters in Queries

5 CTX_ADM Package

6 CTX_CLS Package

7 CTX_DDL Package

8 CTX_DOC Package

9 CTX_OUTPUT Package

10 CTX_QUERY Package

11 CTX_REPORT

12 CTX_THES Package

13 CTX_ULEXER Package

14 Executables

A Result Tables

B Supported Document Formats

C Loading Examples

D Supplied Stoplists

E Alternate Spelling Conventions

F Scoring Algorithm

G Views

H Stopword Transformations

I English Knowledge Base Category Hierarchy

Index