CREATE_STOPLIST
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, the text table must contain a language column.
Add either stopwords, stopclasses, or stopthemes to a stoplist using ADD_STOPWORD, ADD_STOPCLASS, or ADD_STOPTHEME. Specify a stoplist in the parameter string of CREATE INDEX or ALTER INDEX to override the default stoplist CTXSYS.DEFAULT_STOPLIST.
Syntax
CTX_DDL.CREATE_STOPLIST(stoplist_name IN VARCHAR2,
stoplist_type IN VARCHAR2 DEFAULT 'BASIC_STOPLIST');stoplist_name
Specify the name of the stoplist to be created.
stoplist_type
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.
Note: When indexing a multi-language table with a multi-language stoplist, the table must have a language column.
Examples
Example 8-2 Single Language Stoplist
The following example creates a stoplist called mystop:
begin
ctx_ddl.create_stoplist('mystop', 'BASIC_STOPLIST');
end;Example 8-3 Multi-Language Stoplist
The following example 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;