Oracle index with wild card - TechRepublic
General discussion
October 31, 2002 at 05:20 AM
aselvan

Oracle index with wild card

by aselvan . Updated 23 years, 8 months ago

Folks, Is there a way to make Oracle use the index (funtion based) in a search query with wild card at both ends as in the following.

SELECT “NAME”, “DESCRIPTION”
FROM MY_TABLE
WHERE UPPER(“DESCRIPTION”) LIKE ‘%ABC%’

This discussion is locked

All Comments