Re: How to "Case Insensitive"

If you go for the function based index. I think you may have to wrap the predicate in an NVL() function to get it to work ?

where NVL(upper(column_name),'') = 'FRED'

This also sems to worsk if applied to the create index statement.

I did this in the create index statement rather than the select statement with a simlar problem unsing SUBSTR()'s

In article <398948F2.6EBA_at_yahoo.com>,
  connor_mcdonald_at_yahoo.com wrote:
> Real R. Bedard wrote:
> >
> > How do I make Oracle queries (from all users in all
> > databases/schemas/tables) case insensitive.
> >
> > example:
> > SELECT * FROM mytable WHERE name = 'fred'
> > should have the same result as
> > SELECT * FROM mytable WHERE name = 'FReD'
> >
> > similarly for ORDER BY etc.
> >
> > Is there a global setting for this?
> >
> > Your assistance is greatly appreciated.
> >
> > Please RSVP via e-mail
> > Thanks
> >
> > Real R. Bedard
> > realb_at_helixdp.com
>
> where upper(column_name) = 'FRED'
>
> Note that the use of upper with disable index use unless you have a
> function based index. For details on how to activate them, see my
> webpage..
>
> HTH
> --
> ===========================================
> Connor McDonald
> http://www.oracledba.co.uk
>
> We are born naked, wet and hungry...then things get worse
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Aug 03 2000 - 00:00:00 CDT