Re: How configure Oracle 9i not case sensitive...

"Thomas Kellerer" <OSCUQDVXTKFJ_at_spammotel.com> wrote in message news:c6bche$a7g9q$1_at_ID-13919.news.uni-berlin.de...
|
|
| On 23.04.2004 11:21 Eloy Mier Pérez wrote:
|
| > Hi, i would configure Oracle 9i not case sensitive and in the table
names
| > dont use ""...
| >
| > How can i do this ?
| >
| > Thanks in advance
| >
| >
|
| But Oracle is not case sensitive.
|
| SELECT * FROM table;
|
| is identical to
|
| SELECT * FROM TABLE;
|
| Or am I missing something here?
|
| Thomas

perhaps, or perhaps the replies to or reading of the OP were missing something

create table "tablename" ( ....

if not the same as

create table tablename ( ....

because the double-quoted object name (ie, this applies to tables, views, indexes, column names, etc.) forces oracle to create the object in the exact case specified (and would also allow normally illegal characters)

once this is done (either on purpose or by certain migration tools -- i think some MS Access utilities would cause this to happen) oracle in effect becomes case-sensitive in dealing with the table name

so select * from tablename .... would not work, but select * from "tablename" ... would

regarding 3rd party utilities, tools, etc. choking on this -- many will, but some that rely on extracting object names from oracle's data dictionary may not, as many of them will wrap the name they get from the data dictionary in quotes

• mcs