How to "Case Insensitive"

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 Received on Wed Aug 02 2000 - 00:00:00 CDT