Oracle的全文检索

Oracle的全文检索技术

create index INDEX_NAME on Ttable_name(column_name) INDEXTYPE IS CTXSYS.CONTEXT;

select * from table_name where contains(column_name,'Search text ') >0;

Oracle Text组件可以在安装数据库的时候选择，缺省是安装的.

if oracle didn't install , it will meet error:

ORA-29833: indextype does not exist
29833. 00000 -  "indextype does not exist"
*Cause:    There is no indextype by the specified name.
*Action:   Use public views for the indextypes to see if an
           indextype by the specified name has been created.