Home » Other » General » oracle case sensitive
oracle case sensitive [message #192668] Wed, 13 September 2006 03:57 Go to next message
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 #192825 is a reply to message #192668] Wed, 13 September 2006 16:29 Go to previous messageGo to next message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In what way? Usernames and passwords aren't case sensitive; table names (except in certain circumstances), column names, reserved words, ... also aren't case sensitive. Where else would you like Oracle not to take care about case?

Or, are you talking about DATA stored into columns and would like to have

WHERE column = 'Croatia'
equal to
WHERE column = 'croatia'

If so, I'd say that you can't force Oracle to behave like that - in such a case, you should use string functions (for example, UPPER or LOWER).

Or do you have something else in mind?
Re: oracle case sensitive [message #192855 is a reply to message #192668] Wed, 13 September 2006 23:29 Go to previous messageGo to next message
sunsanvin
Messages: 60
Registered: April 2006
Location: Hyderabad
Member

while retrieving data like in the example you said, oracle should be case sensitive
Re: oracle case sensitive [message #192861 is a reply to message #192855] Thu, 14 September 2006 00:01 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
See this link or this
And another one.

Man, I love this new invention!

[Updated on: Thu, 14 September 2006 00:03]

Report message to a moderator

Re: oracle case sensitive [message #192863 is a reply to message #192861] Thu, 14 September 2006 00:14 Go to previous messageGo to next message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Man, I live in the past Embarassed
Re: oracle case sensitive [message #192869 is a reply to message #192863] Thu, 14 September 2006 00:37 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Littlefoot wrote on Thu, 14 September 2006 07:14

Man, I live in the past Embarassed

Be glad! Everything was better back then (or so I am told over and over Wink)
Re: oracle case sensitive [message #392789 is a reply to message #192668] Thu, 19 March 2009 05:10 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #392860 is a reply to message #392846] Thu, 19 March 2009 09:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no problem, just correct (means following the documentation) use.

Regards
Michel
Re: oracle case sensitive [message #393026 is a reply to message #392846] Fri, 20 March 2009 01:05 Go to previous messageGo to next message
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

Re: oracle case sensitive [message #393150 is a reply to message #392846] Fri, 20 March 2009 09:33 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Picking on a 2+ year post is not fair either Wink.
Just to add, passwords can be made case sensitive in 11g.
Previous Topic: General Oracle Support Que
Next Topic: Oracle DB migration
Goto Forum:
  


Current Time: Thu Apr 18 16:08:51 CDT 2024