Oracle case sensitivity

[#1]

My application (WizSource Source Control) comes in PB10 and PB10.5 versions and is designed to work with various databases.

I have come across a problem with Oracle which appears to be caused by queries being case sensitive.

I am pretty sure there is a session command I can use to change it to case insensitive but what exactly the command is, I don't know.

I would appreciate it if an Oracle guru could give an example.

Thanks,

Roland

[Former Member]

Roland

The case sensitivity usually occurs because you have the element in quotes, remove the quotes and it will be case insensitive. Elements in oracle are automatically up-shifted when they are created in the database unless you wrap them in quotes, in which case you can have mixed case.

If you want to email directly with the SQL I'll give you the altered syntax.

Cheers

David