A stopword is a word that is not to be indexed. A stopword is usually a low information word such as a, the, this, or with in English. A stoplist is a list of stopwords. Oracle Text supplies a stoplist for every language. By default during indexing, the system uses the Oracle Text default stoplist for your language.
You can edit the default stoplist CTXSYS.DEFAULT_STOPLIST
or create your own with the following PL/SQL procedures:
CTX_DDL.CREATE_STOPLIST
, create a stoplistCTX_DDL.ADD_STOPWORD
, add a word to a stoplistCTX_DDL.REMOVE_STOPWORD
, remove a word from a stoplistCTX_DDL.DROP_STOPLIST
, drop a stoplistFor detailed information about these procedures, see the description of CTX_DDL
Package in the Oracle Text Reference.
Suppose that you decide that the word forget should not be indexed. Follow these steps to create a new stoplist consisting of the default English stoplist with the word forget added:
MY_STOPLIST
in the current schema, you must drop the stoplist if it already exits, create a basic stoplist, and add the word forget to the stoplist. To do this, enter the following statements in the Enter SQL Statement Window:
BEGIN
CTX_DDL.DROP_STOPLIST('MY_STOPLIST');
CTX_DDL.CREATE_STOPLIST('MY_STOPLIST', 'BASIC_STOPLIST');
CTX_DDL.ADD_STOPWORD('MY_STOPLIST', 'forget');
END;
Note: If MY_STOPLIST
does not exist, the DROP_STOPLIST
statement is not required.
MY_STOPLIST
is created in current schema.MY_STOPLIST
instead of the default stoplist.Copyright © 2008, Oracle. All rights reserved.