oracle创建全文索引(oracle text)

table test.QQ_MsgRecord; CREATE TABLE test.QQ_MsgRecord ( msg_group VARCHAR2(200), msg_object VARCHAR2(200), msg_TIME VARCHAR2(200), msg_FROM VARCHAR2(200), msg_content VARCHAR2(4000) );

--创建全文索引
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;

技术分享

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