Oracle Text Reference -- Index

- operator, 3-27

! operator, 3-39

escape character, 4-3

$ operator, 3-40

% wildcard, 3-52

* operator, 3-50

, operator, 3-9

= operator, 3-15

> operator, 3-44

? operator, 3-16

_ wildcard, 3-52

{} escape character, 4-3

ABOUT query, 3-6

example, 3-8

highlight markup, 7-14

highlight offsets, 7-10

viewing expansion, 9-6

accumulate operator, 3-9

scoring, 3-9

stopword transformations, H-4

ADD_ATTR_SECTION procedure, 6-3

ADD_EVENT procedure, 8-2

ADD_FIELD_SECTION procedure, 6-5

ADD_SPECIAL_SECTION procedure, 6-11

ADD_STOP_SECTION procedure, 6-14

ADD_STOPCLASS procedure, 6-13

ADD_STOPTHEME procedure, 6-16

ADD_STOPWORD procedure, 6-17

ADD_SUB_LEXER procedure, 6-19

example, 2-46

ADD_ZONE_SECTION procedure, 6-22

AL24UTFFSS character set, 2-48

ALTER INDEX, 1-2

examples, 1-10

rebuild syntax, 1-4

rename syntax, 1-3

ALTER_PHRASE procedure, 10-3

ALTER_THESAURUS procedure, 10-5

alternate spelling

about, E-2

Danish, E-4

disabling example, 6-51, E-2

enabling example, E-2

German, E-3

Swedish, E-5

alternate_spelling attribute, 2-45

American

index defaults, 2-71

AND operator, 3-11

stopword transformations, H-3

attribute section

defining, 6-3

dynamically adding, 1-12

querying, 3-54

attribute sections

adding dynamically, 1-8

WITHIN example, 3-57

attributes

alternate_spelling, 2-45

base_letter, 2-42

binary, 2-8

charset, 2-24

command, 2-31

composite, 2-43

continuation, 2-39

detail_key, 2-8

detail_lineno, 2-8

detail_table, 2-8

detail_text, 2-8

disabling, 6-51

endjoins, 2-41

ftp_proxy, 2-14

fuzzy_match, 2-57

fuzzy_numresults, 2-57

fuzzy_score, 2-57

http_proxy, 2-14

i_index_clause, 2-63

i_table_clause, 2-62

index_text, 2-44

index_themes, 2-43

k_table_clause, 2-62

maxdocsize, 2-14

maxthreads, 2-13

maxurls, 2-14

mixed_case, 2-42

n_table_clause, 2-63

newline, 2-42

no_proxy, 2-14

numgroup, 2-39

numjoin, 2-39

output_type, 2-17

p_table_clause, 2-63

path, 2-11

printjoins, 2-40

procedure, 2-16

punctuations, 2-40

r_table_clause, 2-62

setting, 6-48

skipjoins, 2-41

startjoins, 2-41

stemmer, 2-56

timeout, 2-13

urlsize, 2-13

viewing, G-10

viewing allowed values, G-10

whitespace, 2-42

AUTO stemming, 2-55

AUTO_SECTION_GROUP example, 2-67

AUTO_SECTION_GROUP object, 1-34, 2-65, 6-31

AUTO_SECTION_GROUP system-defined preference, 2-72

backslash escape character, 4-3

base_letter attribute, 2-42

BASIC_LEXER object, 2-38

supported character sets, 2-38

BASIC_LEXER system-defined preference, 2-72

BASIC_LEXER type

example, 2-45

BASIC_SECTION_GROUP object, 1-34, 2-65, 6-30

BASIC_STOPLIST type, 6-33

BASIC_STORAGE object

attributes for, 2-62

defaults, 2-63

example, 2-63

BASIC_WORDLIST object

attributes for, 2-55

example, 2-59

BFILE column

indexing, 1-22

BINARY

format column value, 1-25

binary attribute, 2-8, 2-20

BLOB column

indexing, 1-22

loading example, C-3

brace escape character, 4-3

brackets

altering precedence, 3-5, 4-2

grouping character, 4-2

broader term operators

example, 3-12

broader term query feedback, 9-9

BROWSE_WORDS procedure, 9-2

browsing words in index, 9-2

BT function, 10-7

BT operator, 3-12

BTG function, 10-10

BTG operator, 3-12

BTI function, 10-12

BTI operator, 3-12

BTP function, 10-14

BTP operator, 3-12

case-sensitive

ABOUT queries, 3-7

case-sensitive index

creating, 2-42

categories in knowledge catalog, I-1

CATSEARCH operator, 1-13

CHAR column

indexing, 1-22

character sets

Chinese, 2-47

Japanese, 2-48

Korean, 2-49, 2-51

characters

continuation, 2-39

numgroup, 2-39

numjoin, 2-39

printjoin, 2-40

punctuation, 2-40

skipjoin, 2-41

specifying for newline, 2-42

specifying for whitespace, 2-42

startjoin and endjoin, 2-41

character-set

indexing mixed columns, 2-24

character-set conversion

with INSO_FILTER, 2-28

charset attribute, 2-24

charset column, 1-24

CHARSET_FILTER

attributes for, 2-24

mixed character-set example, 2-25

Chinese

fuzzy matching, 2-56

Chinese character sets supported, 2-47

Chinese text

indexing, 2-47

CHINESE_VGRAM_LEXER object, 2-47

CLOB column

indexing, 1-22

clump size in near operator, 3-31

columns types

supported for CTXCAT index, 1-31, 1-34

supported for indexing, 1-22

command attribute, 2-31

composite attribute

BASIC_LEXER, 2-43

KOREAN_MORP_LEXER, 2-52

composite textkey

encoding, 7-20

composite word dictionary, 2-43

composite word index

creating for German or Dutch text, 2-43

composite words

viewing, 9-6

concepts in knowledge catalog, I-1

CONTAINS operator

example, 1-19

syntax, 1-18

CONTEXT index

about, 1-21

default parameters, 2-75

syntax, 1-22

context indextype, 1-21

continuation attribute, 2-39

control file example

SQL*Loader, C-4

COUNT_HITS procedure, 9-5

CREATE INDEX, 1-21

CONTEXT, 1-22

CTXCAT, 1-31

CTXRULE, 1-34

default parameters, 2-75

CREATE_PHRASE procedure, 10-16

CREATE_PREFERENCE procedure, 6-27

CREATE_RELATION procedure, 10-18

CREATE_SECTION_GROUP procedure, 6-30

CREATE_STOPLIST procedure, 6-33

CREATE_THESAURUS function, 10-20

CREATE_TRANSLATION procedure, 10-21

CTX_ADM package

RECOVER, 5-2

SET_PARAMETER, 5-3

SHUTDOWN, 5-5

CTX_CLASSES view, G-4

CTX_DDL package

ADD_ATTR_SECTION, 6-3

ADD_FIELD_SECTION, 6-5

ADD_SPECIAL_SECTION, 6-11

ADD_STOP_SECTION, 6-14

ADD_STOPCLASS, 6-13

ADD_STOPTHEME, 6-16

ADD_STOPWORD, 6-17

ADD_SUB_LEXER, 6-19

ADD_ZONE_SECTION, 6-22

CREATE_PREFERENCE, 6-27

CREATE_SECTION_GROUP, 6-30

CREATE_STOPLIST, 6-33

DROP_PREFERENCE, 6-36

DROP_STOPLIST, 6-38

OPTIMIZE_INDEX procedure, 6-39

REMOVE_SECTION, 6-43

REMOVE_STOPCLASS, 6-45

REMOVE_STOPTHEME, 6-46

REMOVE_STOPWORD, 6-47

SET_ATTRIBUTE, 6-48

SYNC_INDEX procedure, 6-49

UNSET_ATTRIBUTE, 6-51

CTX_DOC package, 7-1

FILTER, 7-2

GIST, 7-5

HIGHLIGHT, 7-10

IFILTER, 7-13

MARKUP, 7-14

PKENCODE, 7-20

result tables, A-8

SET_KEY_TYPE, 7-22

THEMES, 7-23

TOKENS, 7-26

CTX_DOC_KEY_TYPE system parameter, 2-74

CTX_FEEDBACK_ITEM_TYPE type, A-7

CTX_FEEDBACK_TYPE type, 9-10, A-7

CTX_INDEX_ERRORS view, G-5

example, 1-29

CTX_INDEX_OBJECTS view, G-5

CTX_INDEX_SET_INDEXES view, G-7

CTX_INDEX_SUB_LEXERS view, G-7, G-21

CTX_INDEX_SUB_LEXERS_VALUES view, G-8

CTX_INDEX_VALUES view, G-9

CTX_INDEXES view, G-4

CTX_OBJECT_ATTRIBUTE_LOV view, G-10

CTX_OBJECT_ATTRIBUTES view, G-10

CTX_OBJECTS view, G-9

CTX_OUTPUT package, 8-1

ADD_EVENT, 8-2

END_LOG, 8-3

LOGFILENAME, 8-4

REMOVE_EVENT, 8-5

START_LOG, 8-6

CTX_PARAMETERS view, 2-74, G-11

CTX_PENDING view, G-13

CTX_PREFERENCE_VALUES view, G-14

CTX_PREFERENCES view, G-13

CTX_QUERY package

BROWSE_WORDS, 9-2

COUNT_HITS, 9-5

EXPLAIN, 9-6

HFEEDBACK, 9-9

REMOVE_SQE, 9-14

result tables, A-2

STORE_SQE, 9-15

CTX_SECTION_GROUPS view, G-15

CTX_SECTIONS view, G-14

CTX_SERVERS view, G-15

CTX_SQES view, G-16

CTX_STOPLISTS view, G-16

CTX_STOPWORDS view, G-16

CTX_SUB_LEXERS view, G-17

CTX_THES package, 10-1

ALTER_PHRASE, 10-3

ALTER_THESAURUS, 10-5

BT, 10-7

BTG, 10-10

BTI, 10-12

BTP, 10-14

CREATE_PHRASE, 10-16

CREATE_RELATION, 10-18

CREATE_THESAURUS, 10-20

DROP_PHRASE, 10-22

DROP_RELATION, 10-24

DROP_THESAURUS, 10-27

NT, 10-30

NTG, 10-33

NTI, 10-35

NTP, 10-37

OUTPUT_STYLE, 10-39

PT, 10-40

result tables, A-12

RT, 10-42

SN, 10-44

SYN, 10-45

THES_TT, 10-48

TR, 10-49

TRSYN, 10-51

TT, 10-53

CTX_THESAURI view, G-17

CTX_THES.CREATE_TRANSLATION, 10-21

CTX_THES.DROP_TRANSLATION, 10-28

CTX_THES.UPDATE_TRANSLATION, 10-55

CTX_USER_INDEX_ERRORS view, G-19

example, 1-29

CTX_USER_INDEX_OBJECTS view, G-19

CTX_USER_INDEX_SET_INDEXES view, G-20

CTX_USER_INDEX_SETS view, G-20

CTX_USER_INDEX_SUB_LEXERS view, G-21

CTX_USER_INDEX_VALUES view, G-22

CTX_USER_INDEXES view, G-18

CTX_USER_PENDING view, G-22

CTX_USER_PREFERENCE_VALUES view, G-23

CTX_USER_PREFERENCES view, G-22

CTX_USER_SECTION_GROUPS view, G-23

CTX_USER_SECTIONS view, G-23

CTX_USER_SQES view, G-24

CTX_USER_STOPLISTS view, G-24

CTX_USER_STOPWORDS view, G-24

CTX_USER_SUB_LEXERS view, G-25

CTX_USER_THES_PHRASES view, G-25

CTX_USER_THESAURI view, G-25

CTX_VERSION view, G-26

CTXCAT index

about, 1-21

default parameters, 2-76

supported preferences, 1-31

syntax, 1-31

unsupported preferences, 1-32

ctxkbtc complier, 11-6

ctxload, 11-2

examples, 11-5

import file structure, C-6

CTXRULE index

about, 1-21

default parameters, 2-77

syntax, 1-34

ctxsrv

Inso variables in startup shell, B-3

shutting down, 5-5

viewing active servers, G-15

Danish

alternate spelling, E-4

index defaults, 2-71

supplied stoplist, D-3

data storage

defined procedurally, 2-16

direct, 2-3

example, 6-27

external, 2-11

master/detail, 2-8

URL, 2-12

datastore types, 2-3

DATE column, 1-22

default index

example, 1-27

default parameters

changing, 2-77

CONTEXT index, 2-75

CTXCAT index, 2-76

CTXRULE index, 2-77

viewing, 2-77

DEFAULT thesaurus, 3-13, 3-29

DEFAULT_CTXCAT_INDEX_SET system parameter, 2-76

DEFAULT_CTXCAT_LEXER system parameter, 2-76

DEFAULT_CTXCAT_STOPLIST system parameter, 2-76

DEFAULT_CTXCAT_STORAGE system parameter, 2-76

DEFAULT_CTXCAT_WORDLIST system parameter, 2-76

DEFAULT_CTXRULE_LEXER system parameter, 2-77

DEFAULT_CTXRULE_STOPLIST system parameter, 2-77

DEFAULT_CTXRULE_WORDLIST system parameter, 2-77

DEFAULT_DATASTORE system parameter, 2-75

DEFAULT_DATASTORE system-defined indexing preference, 2-70

DEFAULT_FILTER_BINARY system parameter, 2-75

DEFAULT_FILTER_FILE system parameter, 2-75

DEFAULT_FILTER_TEXT system parameter, 2-75

DEFAULT_INDEX_MEMORY system parameter, 2-74

DEFAULT_LEXER system parameter, 2-76

DEFAULT_LEXER system-defined indexing preference, 2-71

DEFAULT_RULE_STORAGE system parameter, 2-77

DEFAULT_SECTION_HTML system parameter, 2-75

DEFAULT_SECTION_TEXT system parameter, 2-76

DEFAULT_STOPLIST system parameter, 2-76

DEFAULT_STOPLIST system-defined preference, 2-73

DEFAULT_STORAGE system parameter, 2-76

DEFAULT_STORAGE system-defined preference, 2-73

DEFAULT_WORDLIST system parameter, 2-76

DEFAULT_WORDLIST system-defined preference, 2-73

defaults for indexing

viewing, G-11

derivational stemming

enabling for English, 2-56

DETAIL_DATASTORE object, 2-8

example, 2-8

detail_key attribute, 2-8

detail_lineno attribute, 2-8

detail_table attribute, 2-8

detail_text attribute, 2-8

dictionary

Korean, 2-51

user, 2-43

DIRECT_DATASTORE object, 2-3

example, 2-3

disambiguators

in thesaural queries, 3-12

in thesaurus import file, C-9

DML

affect on scoring, F-3

DML errors

viewing, G-5

DML processing

batch, 1-4

DML queue

viewing, G-13

document

filtering to HTML and plain text, 7-2

document filtering

Inso, B-2

document formats

supported, B-5

unsupported, B-14

document loading

SQL*Loader, C-3

document presentation

procedures, 7-1

document services

logging requests, 8-6

double-truncated queries, 3-52

double-truncated searching

improving performance, 2-57

DROP INDEX, 1-36

DROP_PHRASE procedure, 10-22

DROP_PREFERENCE procedure, 6-36

DROP_RELATION procedure, 10-24

DROP_STOPLIST procedure, 6-38

DROP_THESAURUS procedure, 10-27

DROP_TRANSLATION procedure, 10-28

Dutch

composite word indexing, 2-43

fuzzy matching, 2-56

index defaults, 2-71

stemming, 2-55

supplied stoplist, D-4

empty indexes

creating, 1-27

EMPTY_STOPLIST system-defined preference, 2-73

END_LOG procedure, 8-3

endjoins attribute, 2-41

English

fuzzy matching, 2-56

index defaults, 2-71

supplied stoplist, D-2

english attribute (Korean lexer), 2-52

environment variables

setting for Inso filter, B-3

equivalence operator, 3-15

stopword transformations, H-6

with NEAR, 3-32

errors

indexing, 1-29

escaping special characters, 4-3

EXP_TAB table type, A-12

expansion operator

soundex, 3-39

stem, 3-40

viewing, 9-6

EXPLAIN procedure, 9-6

example, 9-8

result table, A-2

explain table

creating, 9-7

retrieving data example, 9-8

structure, A-2

extending knowledge base, 11-6

external filters

specifying, 2-31

failed index operation

resuming, 1-6

features

new, xxv

field section

defining, 6-5

limitations, 6-7

querying, 3-54

field sections

adding dynamically, 1-8

repeated, 3-57

WITHIN example, 3-56

file data storage

example, 6-27

FILE_DATASTORE object, 2-11

example, 2-11

FILE_DATASTORE system-defined preference, 2-70

filter formats

supported, B-5

FILTER procedure, 7-2

example, 7-4

in-memory example, 7-3

result table, A-8

filter table

structure, A-8

filter types, 2-23

filtering

to plain text, 7-13

to plain text and HTML, 7-2

filters

character-set, 2-24

Inso, 2-26, B-2

user, 2-31

Finnish

index defaults, 2-72

supplied stoplist, D-5

format column, 1-25

formatted documents

filtering, 2-26

fragmentation of index, 1-27

French

fuzzy matching, 2-56

supplied stoplist, D-6

French stemming, 2-55

ftp_proxy attribute, 2-14

fuzzy matching

automatic language detection, 2-56

example for enabling, 2-59

specifying a language, 2-57

fuzzy operator, 3-16

fuzzy_match attribute, 2-57

fuzzy_numresults attribute, 2-57

fuzzy_score attribute, 2-57

German

alternate spelling attribute, 2-45

alternate spelling conventions, E-3

composite word indexing, 2-43

fuzzy matching, 2-56

index defaults, 2-71

stemming, 2-55

supplied stoplist, D-7

gist

generating, 7-5

GIST procedure

example, 7-8

result table, A-8

updated syntax, 7-5

Gist table

structure, A-8

hanja attribute, 2-52

HASPATH operator, 3-18

HFEEDBACK procedure, 9-9

example, 9-10

result table, A-5

hierarchical query feedback information

generating, 9-9

hierarchical relationships

in thesaurus import file, C-8

HIGHLIGHT procedure, 7-10

example, 7-12

result table, A-10

highlight table

example, 7-12

structure, A-10

highlighting

generating markup, 7-14

generating offsets, 7-10

with NEAR operator, 3-33

hit counting, 9-5

HOME environment variable

setting for INSO, B-3

homographs

in broader term queries, 3-13

in queries, 3-12

in thesaurus import file, C-9

HTML

bypassing filtering, 2-27

filtering to, 7-2

generating highlight offsets for, 7-10

highlight markup, 7-14

highlighting example, 7-18

indexing, 1-34, 2-30, 2-65, 6-30

zone section example, 6-23

HTML_SECTION_GROUP

example, 2-66

HTML_SECTION_GROUP object, 1-34, 2-65, 6-23, 6-30

with NULL_FILTER, 2-30

HTML_SECTION_GROUP system-defined preference, 2-72

http_proxy attribute, 2-14

i_index_clause attribute, 2-63

i_table_clause attribute, 2-62

IFILTER procedure, 7-13

IGNORE

format column value, 1-25

import file

examples of, C-11

structure, C-6

index

creating, 1-21

renaming, 1-3

viewing registered, G-4

index creation

custom preference example, 1-27

default example, 1-27

index creation parameters

example, 2-63

index errors

deleting, 1-30

viewing, 1-29

index fragmentation, 1-27

index maintenance, 1-2

index objects, 2-1

viewing, G-5, G-9

index optimization, 1-6

index preference

about, 2-2

creating, 2-2, 6-27

index requests

logging, 8-6

index tablespace parameters

specifying, 2-62

index tokens

generating for a document, 7-26

index_text attribute, 2-44

index_themes attribute, 2-43

indexing

master/detail example, 2-10

parallel, 1-23

themes, 2-43

indextype context, 1-21

inflectional stemming

enabling, 2-56

INPATH operator, 3-20

INSERT statement

loading example, C-2

Inso filter

index preference object, 2-26

setting up, B-2

supported formats, B-5

supported platforms, B-2

unsupported formats, B-14

INSO_FILTER object, 2-26

character-set conversion, 2-28

INSO_FILTER system-defined preference, 2-71

inverse frequency scoring, F-2

Italian

fuzzy matching, 2-56

stemming, 2-55

supplied stoplist, D-8

JA16EUC character set, 2-48

JA16SJIS character set, 2-48

Japanese

fuzzy matching, 2-56

index defaults, 2-72

indexing, 2-48

japanese attribute (Korean lexer), 2-52

Japanese character sets supported, 2-48

Japanese EUC character set, 2-48

JAPANESE_LEXER, 2-48

JAPANESE_VGRAM_LEXER object, 2-48

JOB_QUEUE_PROCESSES initialization parameter, 1-23

k_table_clause attribute, 2-62

knowledge base

supported character set, 11-6

user-defined, 11-10

knowledge base extension compiler, 11-6

knowledge catalog

category hierarchy, I-1

KO16KSC5601 character set, 2-49, 2-51

Korean

fuzzy matching, 2-56

index defaults, 2-72

korean character sets supported, 2-49, 2-51

Korean text

indexing, 2-50

KOREAN_LEXER object, 2-49

KOREAN_MORP_LEXER, 2-50

composite example, 2-53

supplied dictionaries, 2-51

language

setting, 2-37

language column, 1-25

left-truncated searching

improving performance, 2-57

lexer types, 2-37

loading text

SQL INSERT example, C-2

SQL*Loader example, C-3

loading thesaurus, 11-2

LOB columns

loading, C-3

LOG_DIRECTORY system parameter, 2-74, 8-4

LOGFILENAME procedure, 8-4

logging index requests, 8-6

logical operators

with NEAR, 3-32

LONG columns

indexing, 1-22

long_word attribute, 2-52

maintaining index, 1-2

MARKUP procedure, 7-14

example, 7-18

HTML highlight example, 7-18

result table, A-10

markup table

example, 7-18

structure, A-10

master/detail data storage, 2-8

example, 2-8, 6-28

master/detail tables

indexing example, 2-10

MAX_INDEX_MEMORY system parameter, 2-74

max_span parameter in near operator, 3-31

maxdocsize attribute, 2-14

maxthreads attribute, 2-13

maxurls attribute, 2-14

memory

for index synchronize, 1-7

for indexing, 1-7, 1-26, 6-49

META tag

creating field sections for, 6-7

creating zone section for, 6-23

MINUS operator, 3-27

stopword transformations, H-5

mixed character-set columns

indexing, 2-24

mixed_case attribute, 2-42

mixed-format columns

filtering, 2-26

indexing, 2-27

supported formats for, B-5

morpheme attribute, 2-52

MULTI_LEXER object

CREATE INDEX example, 1-28

example, 2-46

MULTI_LEXER type, 2-46

MULTI_STOPLIST type, 6-33

multi-language indexing, 6-19

multi-language stoplist, 2-46, 2-68

multi-language tables

querying, 1-19, 2-47

n_table_clause attribute, 2-63

narrower term operators

example, 3-28

narrower term query feedback, 9-9

NEAR operator, 3-31

backward compatibility, 3-33

highlighting, 3-33

scoring, 3-32

stopword transformations, H-6

with other operators, 3-32

with within, 3-55

nested section searching, 3-56

nested zone sections, 6-25

nested_column attribute, 2-20

NESTED_DATASTORE attribute, 2-21

NESTED_DATASTORE object, 2-20

nested_lineno attribute, 2-20

nested_text attribute, 2-20

nested_type attribute, 2-20

new features, xxv

newline attribute, 2-42

NEWS_SECTION_GROUP object, 2-66, 6-31

no_proxy attribute, 2-14

nopopulate index parameter, 1-27

Norwegian

index defaults, 2-72

NOT operator, 3-35

stopword transformations, H-5

NT function, 10-30

NT operator, 3-28

NTG function, 10-33

NTG operator, 3-28

NTI function, 10-35

NTI operator, 3-28

NTP function, 10-37

NTP operator, 3-28

NULL_FILTER object, 2-30

NULL_FILTER system-defined preference, 2-71

NULL_SECTION_GROUP object, 2-65, 6-30

NULL_SECTION_GROUP system-defined preference, 2-72

number attribute, 2-51

NUMBER column, 1-22

numgroup attribute, 2-39

numjoin attribute, 2-39

object values

viewing, G-9

objects

viewing index, G-9

offsets for highlighting, 7-10

one_char_word attribute, 2-51

OPERATION column of explain table

values, A-3

OPERATION column of hfeedback table

values, A-6

operator

ABOUT, 3-6

accumulate, 3-9

broader term, 3-12

equivalence, 3-15

fuzzy, 3-16

HASPATH, 3-18

INPATH, 3-20

MINUS, 3-27

narrower term, 3-28

NEAR, 3-31

NOT, 3-35

OR, 3-36

preferred term, 3-37

related term, 3-38

soundex, 3-39

SQE, 3-41

stem, 3-40

synonym, 3-42

threshold, 3-44

top term, 3-49

translation term, 3-45

translation term synonym, 3-47

weight, 3-50

WITHIN, 3-54

operator expansion

viewing, 9-6

operator precedence, 3-3

examples, 3-4

viewing, 9-6

operators, 3-1

OPTIMIZE_INDEX procedure, 6-39

optimizing index, 1-6

OPTIONS column

explain table, A-4

hfeedback table, A-6

OR operator, 3-36

stopword transformations, H-3

OUTPUT_STYLE procedure, 10-39

output_type attribute, 2-17

overlapping zone sections, 6-24

p_table_clause, 2-63

PARAGRAPH keyword, 3-57

paragraph section

defining, 6-11

querying, 3-54

parallel indexing, 1-23

example, 1-29

parameters

setting, 5-3

viewing system-defined, G-11

parentheses

altering precedence, 3-5, 4-2

grouping character, 4-2

partitioned index

example, 1-29

rebuild example, 1-10

path attribute, 2-11

PATH environment variable

setting for Inso, B-3

PATH_SECTION_GROUP

querying with, 3-20

PATH_SECTION_GROUP object, 2-66, 6-31

PATH_SECTION_GROUP system-defined preference, 2-72

pending DML

viewing, G-13

performance

wildcard searches, 3-53

PKENCODE function, 7-20

plain text

bypassing filtering, 2-27

filtering to, 7-2, 7-13

highlight markup, 7-14

indexing, 2-28

indexing with NULL_FILTER, 2-30

offsets for highlighting, 7-10

populate index parameter, 1-27

Portuguese

supplied stoplist, D-9

precedence of operators, 3-3

altering, 3-5, 4-2

equivalence operator, 3-15

example, 3-4

viewing, 9-6

preference classes

viewing, G-4

preference values

viewing, G-14

preferences

about, 2-2

creating, 6-27

dropping, 6-36

replacing, 1-4

specifying for indexing, 1-23

system-defined, 2-70

viewing, G-13

preferred term operator

example, 3-37

prefix_index attribute, 2-58

prefix_length_max attribute, 2-59

prefix_length_min attribute, 2-59

printjoins attribute, 2-40

privileges

required for indexing, 1-21

procedure attribute, 2-16

prove_themes attribute, 2-44

proximity operator, see NEAR operator

PT function, 10-40

PT operator, 3-37

punctuations attribute, 2-40

query

accumulate, 3-9

AND, 3-11

broader term, 3-12

equivalence, 3-15

example, 1-19

hierarchical feedback, 9-9

MINUS, 3-27

narrower term, 3-28

NOT, 3-35

OR, 3-36

preferred term, 3-37

related term, 3-38

stored, 3-41

synonym, 3-42

threshold, 3-44

top term, 3-49

translation term, 3-45

translation term synonym, 3-47

weighted, 3-50

r_table_clause attribute, 2-62

rebuilding index

example, 1-10

syntax, 1-4

RECOVER procedure, 5-2

related term operator, 3-38

related term query feedback, 9-9

relevance ranking

word queries, F-2

REMOVE_EVENT procedure, 8-5

REMOVE_SECTION procedure, 6-43

REMOVE_SQE procedure, 9-14

REMOVE_STOPCLASS procedure, 6-45

REMOVE_STOPTHEME procedure, 6-46

REMOVE_STOPWORD procedure, 6-47

renaming index, 1-3

repeated field sections

querying, 3-57

replacing preferences, 1-4

reserved words and characters, 4-4

escaping, 4-3

result table

TOKENS, A-11

result tables, A-1

CTX_DOC, A-8

CTX_QUERY, A-2

CTX_THES, A-12

resuming failed index, 1-6

example, 1-10

RFC 1738 URL specification, 2-12

RT function, 10-42

RT operator, 3-38

Salton's formula for scoring, F-2

scope notes

finding, 10-44

SCORE operator, 1-38

scoring

accumulate, 3-9

effect of DML, F-3

for NEAR operator, 3-32

scoring algorithm

word queries, F-2

section group

creating, 6-30

viewing information about, G-15

section group example, 2-66

section group types, 2-65, 6-30

section searching, 3-54

nested, 3-56

sections

adding dynamically, 1-4

constraints for dynamic addition, 1-9

creating attribute, 6-3

creating field, 6-5

creating zone, 6-22

nested, 6-25

overlapping, 6-24

removing, 6-43

repeated field, 6-7

repeated zone, 6-24

viewing information on, G-14

SENTENCE keyword, 3-57

sentence section

defining, 6-11

querying, 3-54

server

shutting down, 5-5

viewing active, G-15

SET_ATTRIBUTE procedure, 6-48

SET_KEY_TYPE procedure, 7-22

SET_PARAMETER procedure, 2-74, 5-3

ShiftJis, 2-48

SHUTDOWN procedure, 5-5

Simplified Chinese

index defaults, 2-72

single-byte languages

indexing, 2-38

skipjoins attribute, 2-41

SN procedure, 10-44

soundex operator, 3-39

Spanish

fuzzy matching, 2-56

stemming, 2-55

supplied stoplist, D-10

special section

defining, 6-11

querying, 3-54

SQE operator, 3-41

SQL commands

ALTER INDEX, 1-2

CREATE INDEX, 1-21

DROP INDEX, 1-36

SQL operators

CONTAINS, 1-18

SCORE, 1-38

SQL*Loader

example, C-3

example control file, C-4

example data file, C-5

sqlldr example, C-3

START_LOG procedure, 8-6

startjoins attribute, 2-41

stem operator, 3-40

stemmer attribute, 2-56

stemming, 2-56

automatic, 2-55

example for enabling, 2-59

stop section

adding dynamically, 1-9

dynamically adding example, 1-12

stop sections

adding, 6-14

stop_dic attribute, 2-51

stopclass

defining, 6-13

removing, 6-45

stoplist

creating, 6-33

Danish, D-3

dropping, 6-38

Dutch, D-4

English, D-2

Finnish, D-5

French, D-6

German, D-7

Italian, D-8

modifying, 2-68

multi-language, 2-46, 2-68

Portuguese, D-9

Spanish, D-10

Swedish, D-11

stoplists

about, 2-68

creating, 2-68

viewing, G-16

stoptheme

defining, 6-16

removing, 6-46

stopword

adding dynamically, 1-4, 1-7

defining, 6-17

removing, 6-47

viewing all in stoplist, G-16

stopword transformation, H-2

viewing, 9-6

stopwords

adding dynamically, 2-69

removing, 2-69

storage defaults, 2-63

storage index preference

example, 6-28

storage objects, 2-62

STORE_SQE procedure

example, 3-41

syntax, 9-15

stored queries, 3-41

stored query expression

creating, 9-15

removing, 9-14

viewing, G-24

viewing definition, G-16

sub-lexer values

viewing, G-8

sub-lexers

viewing, G-7, G-17, G-21

substring index

example for creating, 2-59

substring_index attribute, 2-57

supplied stoplists, D-1

Swedish

alternate spelling, E-5

index defaults, 2-72

supplied stoplist, D-11

SYN function, 10-45

SYN operator, 3-42

SYNC_INDEX procedure, 6-49

synonym operator, 3-42

system parameters, 2-74

defaults for indexing, 2-75

system recovery

manual, 5-2

system-defined preferences, 2-70

table structure

explain, A-2

filter, A-8

Gist, A-8

hfeedback, A-5

highlight, A-10

markup, A-10

theme, A-11

tagged text

searching, 3-54

TEXT

format column value, 1-25

text column

supported types, 1-22

Text data dictionary

cleaning up, 5-2

text-only index

enabling, 2-44

example, 6-27

theme base, I-1

theme functionality

supported languages, 11-10

theme highlighting

generating markup, 7-14

generating offsets, 7-10

HTML markup example, 7-19

HTML offset example, 7-12

theme index

as default in English, 2-71

creating, 2-43

theme proving

enabling, 2-44

theme summary

generating, 7-5

generating top n, 7-8

theme table

structure, A-11

theme_language attribute, 2-44

themes

generating for document, 7-23

generating highlight markup, 7-14

highlight offset example, 7-12

indexing, 2-43

obtaining top n, 7-25

THEMES procedure

result table, A-11

syntax, 7-23

THES_TT procedure, 10-48

thesaurus

compiling, 11-6

creating, 10-20

creating relationships, 10-16

DEFAULT, 3-13

dropping, 10-27

import/export examples, 11-5

importing/exporting, 11-2

procedures for browsing, 10-1

renaming and truncating, 10-5

viewing information about, G-17

thesaurus import file

examples, C-11

structure, C-6

thesaurus phrases

altering, 10-3

dropping, 10-22

thesaurus relations

creating, 10-18

dropping, 10-24

thesaurus scope note

finding, 10-44

thesaurus top terms

finding all, 10-48

threshold operator, 3-44

stopword transformations, H-7

timeout attribute, 2-13

to_upper attribute, 2-52

token index optimization, 1-6

TOKENS procedure

result table, A-11

syntax, 7-26

top term operator, 3-49

TR function, 10-49

TR operator, 3-45

transformation

stopword, H-2

translation term operator, 3-45

translation term synonym operator, 3-47

translations

adding to thesaurus, 10-21

dropping, 10-28

updating, 10-55

TRSYN function, 10-51

TRSYN operator, 3-47

TT function, 10-53

TT operator, 3-49

UNIX platforms

setting variables for Inso, B-3

UNSET_ATTRIBUTE procedure, 6-51

UPDATE_TRANSLATION procedure, 10-55

URL syntax, 2-12

URL_DATASTORE object

attributes for, 2-12

example, 2-15

URL_DATASTORE system-defined preference, 2-70

urlsize attribute, 2-13

USER_DATASTORE object, 2-16

example, 2-17

USER_DATSTORE

filtering binary documents, 7-13

user_dic attribute, 2-51

USER_FILTER object, 2-31

example, 2-31

UTF-16 endian auto-detection, 2-24

UTF8, 2-48

UTF8 character set, 2-38, 2-48, 2-49, 2-51

utilities

ctxload, 11-2

VARCHAR2 column

indexing, 1-22

verb_adjective attribute, 2-51

version numbers

viewing, G-26

viewing

operator expansion, 9-6

operator precedence, 9-6

views, G-1

visible flag for field sections, 6-6

visible flag in field sections, 3-56

weight operator, 3-50

stopword transformations, H-7

whitespace attribute, 2-42

wildcard queries

improving performance, 2-58

wildcard searches, 3-52

improving performance, 3-53

wildcard_maxterms attribute, 2-59

WITHIN operator, 3-54

attribute sections, 3-57

limitations, 3-60

nested, 3-56

precedence, 3-4

stopword transformations, H-7

XML documents

attribute sections, 6-3

doctype sensitive sections, 6-24

indexing, 1-34, 2-65, 6-31

querying, 3-57

XML sectioning, 2-67

XML_SECTION_GROUP

example, 2-66

XML_SECTION_GROUP object, 1-34, 2-65, 6-30

ZHS16CGB231280 character set, 2-47

ZHS16GBK character set, 2-48

ZHT16BIG5 character set, 2-48

ZHT32EUC character set, 2-48

ZHT32TRIS character set, 2-48

zone section

adding dynamically, 1-7

creating, 6-22

dynamically adding example, 1-11

querying, 3-54

repeating, 6-24

Index

Symbols

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Z