Re: Oracle case in sensitive

deana strbevski wrote:
>
> You can use upper function
> select ..
> where upper(column) = upper(same_value)
> but then index on column (if any) is not in use
>
> sundarkumar_at_my-deja.com wrote:
>
> > Hi Everyone
> >
> > I want to make oracle case insensitive meaning, if I fire a sql query
> > like
> >
> > Ex : select * from customers where some_value=some_case_sensitive;
> >
> > So this query will pick up only the matched some_case_sensitive value. I
> > don't want it to be checked for case sensitives.
> >
> > Ex "junk"="JUNK" - this data not get returned if I fire the above sql
> > becoz by default sql will pickup the exact match value. I don't want
> > this should not be checked. If I looking for junk, it
> > should take all junk case in sensitive values and return it to me.
> >
> > I am sure there is some parameter to set and achieve this. Pls help me
> > out in this issues...
> >
> > Thanx in Advance...
> >
> > Sundar
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.

unless you add a function based index on UPPER(col)

HTH
Connor

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"