Re: How to "Case Insensitive"

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