您好,登錄后才能下訂單哦!
創建 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$%')
免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。