Page History
...
Code Block | ||
---|---|---|
| ||
begin -- create a custom stoplist ctx_ddl.create_stoplist('example_stoplist, 'BASIC_STOPLIST'); -- add the word 'the' to the stoplist ctx_ddl.add_stopword('example_stoplist', 'the'); end; -- create the full-text index with the custom stoplist create index aq_fulltext_index on aq_fulltext(text) indextype is ctxsys.context parameters ('datastore aq_fulltext_uds stoplist example_stoplist sync(on commit)'); -- dynamically add the stopword 'other' to the index alter index aq_fulltext_index parameters ('add stopword other'); -- rebuild the index and withreplace the samestoplist parameters(perhaps asnew thosestopwords usedwere whenadded itto was created,the stoplist) -- the stopword 'other' is lost, and again present in the index alter index aq_fulltext_index rebuild parameters ('replace stoplist example_stoplist'); |
...
Overview
Content Tools