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'
alter index aq_fulltext_index parameters ('add stopword other);
-- rebuild the index with the same parameters as those used when it was created, the stopword 'other' is lost
alter index aq_fulltext_index rebuild parameters ('replace stoplist example_stoplist');
|
...
Overview
Content Tools