Oracle Text Reference Release 9.0.1 Part Number A90121-01 |
|
CTX_DDL Package, 9 of 28
Use this procedure to add a single stopword to a stoplist.
To create a list of stopwords, you must call this procedure once for each word.
CTX_DDL.ADD_STOPWORD(stoplist_name in varchar2, stopword in varchar2, language in varchar2 default NULL);
Specify the name of the stoplist.
Specify the stopword to be added.
Language-specific stopwords must be unique across the other stopwords specific to the language. For example, it is valid to have a German die and an English die in the same stoplist.
The maximum number of stopwords, stopthemes, and stopclasses you can add to a stoplist is 4095.
Specify the language of stopword
when the stoplist you specify with stoplist_name
is of type MULTI_STOPLIST. You must specify the NLS name or abbreviation of an Oracle-supported language.
To make a stopword active in multiple languages, specify ALL for this parameter. For example, defining ALL stopwords is useful when you have international documents that contain English fragments that need to be stopped in any language.
An ALL stopword is active in all languages. If you use the multi-lexer, the language-specific lexing of the stopword occurs, just as if it had been added multiple times in multiple specific languages.
Otherwise, specify NULL.
The following example adds the stopwords because, notwithstanding, nonetheless, and therefore to the stoplist mystop
:
beginctx_ddl.add_stopword('mystop', 'because'); ctx_ddl.add_stopword('mystop', 'notwithstanding'); ctx_ddl.add_stopword('mystop', 'nonetheless'); ctx_ddl.add_stopword('mystop', 'therefore');end;
The following example adds the German word die to a multi-language stoplist:
beginctx_ddl.add_stopword('mystop', 'Die','german');end;
The following adds the word the as an ALL stopword to the multi-language stoplist globallist:
beginctx_ddl.add_stopword('globallist','the','ALL');end;
ALTER INDEX in Chapter 1, "SQL Statements and Operators".
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|