Re: oracle case in sensitive

Or you can use OMNIDEX keyword indexing. See http://www.disc.com/keyword.html or contact me.

Cheryl Grandy
cgrandy_at_disc.com

In article <93bvli$9hd9b$1_at_ID-62141.news.dfncis.de>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> If you want to do it without upper and/or function based indexes,
 then stick
> just stick to sqlserver.
> The world is case-sensitive, only the evil empire aka Microsoft is
 not.
> Seriously, if you don't want to accept the solutions you outlined,
 there are
> *no* alternatives.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
> <sundarkumar_at_my-deja.com> wrote in message
> news:93bkjk$rn0$1_at_nnrp1.deja.com...
> > Hi Everyone
> >
> > I want to make oracle case in sensitive. I mean if I fire sql like
> >
> > select * from users where name='sun';
> >
> > now it'll basically look for exact match for sun and it will return
> > all the matched recordsd...I want all matches like Sun,SUn,SUN
 etc...
> > which does not look for cases...
> >
> > In SQL Server it's possible to make the value case in sensitive..
 Also
> > in Sybase...
> >
> > Without using upper function / Indexing, I want to do it...So How
 do I
> > it in Oracle??? Pls let me know...
> >
> > My advance thanx for ur solution..
> >
> > Regds
> > Sundar
> >
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
>

--
Cheryl Grandy
DISC
Get OMNIDEX for the fastest
applications ever


Sent via Deja.com
http://www.deja.com/