Page History

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');