|Oracle Text Reference
Part Number A90121-01
CTX_DDL Package, 15 of 28
Use this procedure to create a new, empty stoplist. Stoplists can contain words or themes that are not to be indexed.
You can also create multi-language stoplists to hold language-specific stopwords. A multi-language stoplist is useful when you index a table that contains documents in different languages, such as English, German, and Japanese. When you do so, you text table must contain a language column.
Specify the name of the stoplist to be created.
Specify BASIC_STOPLIST to create a stoplist for a single language. This is the default.
Specify MULTI_STOPLIST to create a stoplist with language-specific stopwords.
At indexing time, the language column of each document is examined, and only the stopwords for that language are eliminated. At query time, the session language setting determines the active stopwords, like it determines the active lexer when using the multi-lexer.
When indexing a multi-language table with a multi-language stoplist, your table must have a language column.
The following code creates a stoplist called
The following code creates a multi-language stoplist called
multistop and then adds tow language-specific stopwords:
begin ctx_ddl.create_stoplist('multistop', 'MULTI_STOPLIST'); ctx_ddl.add_stopword('mystop', 'Die','german'); ctx_ddl.add_stopword('mystop', 'Or','english'); end;