Shulou(Shulou.com)06/01 Report--

Create a 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 uses:

Select * from objects

Where reverse (object_name) LIKE reverse ('% OL$')

Or

Select * from objects

Where reverse (object_name) LIKE ('OL$%')

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.