469,596 Members | 2,288 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,596 developers. It's quick & easy.

case sensitivity in 9i & 10g

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
3 3987
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
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
121 100+
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.

Similar topics

32 posts views Thread by Elliot Temple | last post: by
761 posts views Thread by Neo-LISPer | last post: by
3 posts views Thread by Jason Tesser | last post: by
14 posts views Thread by Christian Sell | last post: by
15 posts views Thread by gregory_may | last post: by
1 post views Thread by othellomy | last post: by
2 posts views Thread by sweetpotatop | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.