|Oracle Text Reference
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.
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
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:
The following adds the word the as an ALL stopword to the multi-language stoplist globallist: