oracle 全文检索

select t.*, t.rowid from test t where t.mycomment
 like '%缩放%'

BEGIN
  ctx_ddl.drop_preference ('my_lexer');
  ctx_ddl.create_preference ('my_lexer', 'chinese_vgram_lexer');
  --ctx_ddl.create_preference ('my_lexer', 'CHINESE_LEXER');
 
END;

CREATE INDEX  myindex ON test(mycomment) indextype is ctxsys.context parameters('lexer my_lexer');

drop index myindex;

select t.*, t.rowid from test t where contains(t.mycomment,'%COM%')>0;

select * from DR$myindex$I;