创建Oracle Text 文本索引:
CREATE INDEX doc_index ON docs(text) INDEXTYPE IS CTXSYS.CONTEXT
查询文本:
select a.content_id, a.content_name, a.content, a.type_id
from (select t.content_id,
t.content_name,
t.content,
t.type_id,
rownum - 1 numNo
from CONTENT_BAIKE t
where 1 = 1
and CONTAINS(t.key_word, '新疆') > 0
and t.type_id = 25000000) a
where a.numNo >= 0
and a.numNo < 10
order by nlssort(a.content_name,'NLS_SORT=SCHINESE_PINYIN_M');