oracle case sensitive [message #192668] |
Wed, 13 September 2006 03:57 |
sunsanvin
Messages: 60 Registered: April 2006 Location: Hyderabad
|
Member |
|
|
dear experts,
is it possible to make Oracle database as IN-casesensitive?
my meaning is that database should not be case sensitive.
is it possible?
thank you very much
|
|
|
|
|
|
|
|
Re: oracle case sensitive [message #392789 is a reply to message #192668] |
Thu, 19 March 2009 05:10 |
wakula
Messages: 150 Registered: February 2008 Location: Poland
|
Senior Member |
|
|
The Oracle BD which I am using seems to be case sensitive (it is Oracle 10.2G):
SQL> CREATE TABLE "MyTable"("myColumn" NUMBER,"mycolumn" VARCHAR2(10));
Table created.
SQL> INSERT INTO "MyTable" ("myColumn","mycolumn") VALUES (1,'col');
1 row created.
SQL> SELECT "mycolumn" from "MyTable";
mycolumn
----------
col
SQL> SELECT "myColumn" from "MyTable";
myColumn
----------
1
SQL> SELECT * FROM mytable;
SELECT * FROM mytable
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> SELECT * FROM MyTable;
SELECT * FROM MyTable
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> SELECT * FROM "mytable";
SELECT * FROM "mytable"
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> SELECT * FROM "MyTable";
myColumn mycolumn
---------- ----------
1 col
Note that:
1) table/column names are enclosed with double quotes
2) when names are lower-case only or upper-case only - Oracle seems to treat them as case insensitive (I have't checked that in details)
3) when names are not surrounded with double quotes - then case insensitive name is used
4) your work will be more difficult if you use case sensitive names
5) if you have a working system - don't implement case sensitive names
6) if you are developing a totally new system - then you might consider using case sensitive names
7) if you want to use case sensitive names - don't do this
8) if you need to use it - you would know that for sure
9) if you feel that you need case sensitive naming then you are probably wrong
|
|
|
Re: oracle case sensitive [message #392837 is a reply to message #392789] |
Thu, 19 March 2009 08:12 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
wakula wrote on Thu, 19 March 2009 06:10 | The Oracle BD which I am using seems to be case sensitive (it is Oracle 10.2G):
|
Huh? So has every version ever made by Oracle up until now and probably every version until the sun goes supernova.
|
|
|
Re: oracle case sensitive [message #392846 is a reply to message #392837] |
Thu, 19 March 2009 08:31 |
wakula
Messages: 150 Registered: February 2008 Location: Poland
|
Senior Member |
|
|
wakula wrote on Thu, 19 March 2009 06:10 | The Oracle BD which I am using seems to be case sensitive (it is Oracle 10.2G):
| Sory for the misspelling.
joy_division wrote on Thu, 19 March 2009 14:12 | Huh? So has every version ever made by Oracle up until now and probably every version until the sun goes supernova.
| Good - it seems that under some circumstances the database acts like case sensitive and under other - case insensitive.
|
|
|
|
Re: oracle case sensitive [message #393026 is a reply to message #392846] |
Fri, 20 March 2009 01:05 |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
wakula wrote on Thu, 19 March 2009 14:31 | Good - it seems that under some circumstances the database acts like case sensitive and under other - case insensitive.
|
The database is always converting object names to uppercase unless explicitly prompted to do otherwise (i.e. by using double quotes).
Data is always treated case-sensitive, unless explicitly told otherwise (e.g. by one of the above mentioned methods)
[Updated on: Fri, 20 March 2009 01:06] Report message to a moderator
|
|
|
|