case sensitivity in 9i & 10g

[Anita Potekkat]

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

[anuj13singhal]

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

Hi Anita,

Case Sensitivity in oracle is with the object names and object columns also.

Suppose you want to create a table NaMes having a coloumn FirsT_NaMe (note the cases).
so, you can create this like :

create table "NaMes" (FirsT_NaMe varchar2(20));

And select like this:

select "FirsT_NaMe " from "NaMes";

if you write

select first_name from names;
select FIRST_NAME from names;
select first_name from NAMES;
select FIRST_NAME from NAMES;

It will give an error, saying table or view does not exists or invalid column name.

I hope this answers your query.

[Anita Potekkat]

Hello Anuj Singhal,

Thanks for your reply.

Can you tell me how to turn on case sensitivity in Oracle 10g/9i?

Thanks
Anita

[bplacker]

I thought that 10g, at least, was not case sensitive, except for the data itself. I'm not sure how to turn it on, I never found a reason to do this.