I dont mean it is not a good idea, the bad idea is your query, if instead of like you use = most probably Oracle will do an index scan

But if you really want to use LIKE operator you have to use Intermedia