Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Reg:Pattern Matching
Hi All,
I have an input parameter say abc. I would like to fetch all the
records from a table that matches (case insensitive) a table column and
the input.
Currently, the implementation is like
select a from table t where UPPER(t.c) = UPPER(input parameter)
Is there any other efficient way to do it to avoid group functions in where clause?
Thanks Received on Mon May 29 2006 - 13:11:35 CDT