472,353 Members | 2,076 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.

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 4140
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

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

Similar topics

32
by: Elliot Temple | last post by:
Hi I have two questions. Could someone explain to me why Python is case sensitive? I find that annoying. Also, why aren't there multiline...
761
by: Neo-LISPer | last post by:
Hey Recently, I researched using C++ for game programming and here is what I found: C++ game developers spend a lot of their time debugging...
16
by: Starwiz | last post by:
I'm a VB.net programmer, and I'm about to start working with two C++ programmers and teach them .net. I've decided to use C# in teaching them,...
3
by: Jason Tesser | last post by:
I am converting data from Access into Postgres and ran into an issue with case sensitivity. Can I write queries in Access that will be case...
14
by: Christian Sell | last post by:
Hello, I am running into a problem with PGs case sensitivity with regard to column and table names. I am using program components that require...
15
by: gregory_may | last post by:
Is there any options in VS 2005 to better handle case issues in C# (Similar to VB.Net)?
1
by: othellomy | last post by:
Is SQL server defaults to case insensitive? I am sure there are ways to install case sensitive SQL server instance but coming from Sybase (which is...
2
by: sweetpotatop | last post by:
Hi, I believe my SQL server was configured as Case sensitivity. I have a number of stored procedures which were moved from a non-Case...
2
by: Lucky | last post by:
Hi guys, I'm having problem with case sensitive collation of SQL Database. one my client is having case sensitive database. While developing the...
1
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
0
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....
0
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.