oracle创建全文索引(oracle text)

--创建全文索引
create   index test.idx_QQ_MsgRecord on test.QQ_MsgRecord(msg_content) indextype is ctxsys.context;
SELECT  * FROM test.QQ_MsgRecord WHERE CONTAINS( msg_content, ‘有‘, 1) > 0;

oracle创建全文索引(oracle text)

标签：ext   .com   img   http   varchar   select   nbsp   alt   code