Filter LIKE ANY
ysriJan 8 2013 — edited Jan 8 2013Hi, I want to rewrite this sql filter condition:
where col1 like '%a' or col1 like 'b%' or col1 like '%c%' or col1 like 'd'
into more simpler format like the way Teradata allows:
where col1 like any ('%a','b%','%c%','d')
What's the equivalent syntax in Oracle? Can REGEXP_LIKE be used?
Any working example please?
Similarly, simpler format for:
where col1 not like '%a' and col1 not like 'b%' and col1 not like '%c%' and col1 not like 'd'
Thanks,
-srinivas y.