oracle创建全文索引(oracle text)

drop 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;

 

转载于:https://www.cnblogs.com/castlevania/p/6693980.html