Hello,
I had a question regarding Case Sensitivity in 10g & 9i.
(1) Does Case Sensitivity in Oracle have to do with data only? Or does it also effect table & column names? For e.g. in a table NAMES with column NAME are the following queries equivalent regardless of whether case sensitivity is turned on or off.
select name from names;
select NAME from names;
select name from NAMES;
select NAME from NAMES;
(2) Is there anyway in Oracle to make the above four queries different. In other words, is there a switch/option that does control the case sensitivity of table & column names.
Thanks
Anita