创建 reverse index :
create table objects
as
select * from dba_objects;
create index obj_idx on objects(OBJECT_NAME) reverse;
create index obj_idx_reverse on objects(reverse(OBJECT_NAME));
reverse index使用:
select * from objects
where reverse(object_name) LIKE reverse('%OL$')
或
select * from objects
where reverse(object_name) LIKE ('OL$%')
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25583515/viewspace-2146401/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25583515/viewspace-2146401/