Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle case in sensitive
Basicly you're right, but there is an option introduced with Oracle 8i called "function-based index". An example is given below:
CREATE INDEX <INDEX_NAME> ON (UPPER(<COLUMN_NAME>));
The index is not used until you gathered statistics about it.
Properly implemented performance won't suffer.
regards,
Marc Staudacher
"deana strbevski" <deana.strbevski_at_ina.hr> wrote in message
news:3A34937C.EC5A4C9D_at_ina.hr...
> 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.
>
Received on Mon Dec 11 2000 - 14:37:34 CST