Hi All,
I have a problem.
My client wants us to make all the procedures only for selects to be case insensitive.
But there is a catch. It should be only applicable to where clause. However the joins etc... should still be case sensitive.
We are in mid of our project and we have around 300 procedures which needs to be changed. This is cumbersome.
I have checked about setting the NLS parameters to have case insensitive search. But, our client is not interested in having them as they do the insensitivity on JOINS as well..
Is there any better approach for this problem . Please help. My oracle version is 11g.