Oracle 反向索引 where index_column like '%xxx'

guocun09發表於2017-10-26
Oracle索引Index

建立 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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章