Re: Reg:Pattern Matching

From: Sybrand Bakker <postbus@xxxxxxxxxxxxxxxxx>
Date: Tue, 30 May 2006 06:44:35 +0200

On 29 May 2006 11:11:35 -0700, suryaprakash.iyer@xxxxxxxxx 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
.

References:
- Reg:Pattern Matching
  - From: suryaprakash . iyer

Prev by Date: Re: Oracle 9 NT Authentication "conn / as sysdba" - Role issue ?
Next by Date: Oracle SQL script needs finetuning in TOAD
Previous by thread: Reg:Pattern Matching
Next by thread: Export and Import
Index(es):
- Date
- Thread