Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Reg:Pattern Matching

Reg:Pattern Matching

From: <suryaprakash.iyer_at_gmail.com>
Date: 29 May 2006 11:11:35 -0700
Message-ID: <1148926294.940124.233150@38g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US