troubleshooting Question

How do I change the default case sensitivity under Oracle 10g/11g?

Avatar of axnst2
axnst2Flag for United States of America asked on
Oracle Database
7 Comments1 Solution976 ViewsLast Modified:
Hi Experts,

      I need to be able to change the default case sensitivity for an Oracle database/schema.  So basically I if I run a SQL query like this:

" SELECT * FROM USERS WHERE UserName='Tom'; "

I would like it to return 'Tom', 'TOM', and 'tom' as well!  I saw that you can do some thing like this:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:16370675423662

but I am wondering if I can just somehow set this as the default for the entire schema/database?

Thanks!
ASKER CERTIFIED SOLUTION
David VanZandt
Sr Software Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros