By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,979 Members | 1,452 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,979 IT Pros & Developers. It's quick & easy.

case sensitivity in 9i & 10g

P: 2
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
Jan 5 '07 #1
Share this Question
Share on Google+
3 Replies


P: 14
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.
Jan 12 '07 #2

P: 2
Hello Anuj Singhal,

Thanks for your reply.

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

Thanks
Anita
Jan 12 '07 #3

bplacker
100+
P: 121
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.
Jan 12 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.