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.