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:
but I am wondering if I can just somehow set this as the default for the entire schema/database?