Re: Reg:Pattern Matching

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 30 May 2006 06:44:35 +0200
Message-ID: <3djn72l369m2onjhsle5h7de6h8h8kek7p@4ax.com>

On 29 May 2006 11:11:35 -0700, suryaprakash.iyer_at_gmail.com wrote:

>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

And your version of Oracle is?

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon May 29 2006 - 23:44:35 CDT