Making an Oracle Database Instance Case - Insensitive

I would like to make an oracle database use case insensitive data storage so that the following query will work

      select col1 from table1 where col1 = 'sanjay kumar'

     col1 may have 'SANJAY KUMAR' or 'Sanjay Kumar' but everything will be matched by the above select statement. There should be some switch/init parameter that I can set to make the database case insensitive.

Any help would be appreciated !!

Thanks
Nirav Saraiya
Netright Technologies
(312) 977 0664 x 223 Received on Tue Dec 30 1997 - 00:00:00 CST