--创建表
CREATE TABLE tb_clob(
userid NUMBER PRIMARY KEY,
text CLOB
);
--建立索引
CREATE INDEX search_idx
ON tb_clob(text)
INDEXTYPE IS ctxsys.CONTEXT;
--查询
SELECT COUNT(*)
FROM tb_clob
WHERE contains(text, 'index', 1) > 0
--创建表
CREATE TABLE tb_clob(
userid NUMBER PRIMARY KEY,
text CLOB
);
--建立索引
CREATE INDEX search_idx
ON tb_clob(text)
INDEXTYPE IS ctxsys.CONTEXT;
--查询
SELECT COUNT(*)
FROM tb_clob
WHERE contains(text, 'index', 1) > 0