We have a application written in Java and running on an Oracle 10g database.
In the application, we have a search column which is case sensative. You must enter the exact spelling and case in order to find a match. I want to be able to search in any case and find a match. How can I remove the case sensative problem ? Is there a dba parameter than I can set ? Thank you.