创建reverse index:

create tableobjects
as
select * from dba_objects;

createindexobj_idx on objects(OBJECT_NAME)reverse;

createindexobj_idx_reverse on objects(reverse(OBJECT_NAME));

reverse index使用：

select* from objects

wherereverse(object_name)LIKEreverse('%OL$')

或

select* from objects

wherereverse(object_name)LIKE('OL$%')