Re: Lower Case for the Data Dictionnary

Hi,

data dictionary IS case sensitiv:
Every Object (tables,columns,etc...) which should be lower/mixed-case has to be in " (shit, what the name for this in english :-) )

Example:

09:20:00 > create table "XXXxxx" ("n" number, N varchar2(30));

09:20:04 > desc "XXXxxx"

 Name                          Null?    Type
 ----------------------------- -------- --------------------
 n                                      NUMBER
 N                                      VARCHAR2(30)

09:20:07 > select * from xxxxxx;
select * from xxxxxx

              *
ERROR at line 1:
ORA-00942: table or view does not exist

09:22:07 > select * from XXXxxx;
select * from XXXxxx

              *
ERROR at line 1:
ORA-00942: table or view does not exist

09:22:27 > select * from "XXXxxx";

no rows selected

Would be awful to me ...

Hth
 Thomas

"dc" <gobills_at_videotron.ca> wrote in message news:<FdFg7.75559$sv1.1912502_at_wagner.videotron.net>...
> Is there a variable I can set when creating the database in order to have
> the definitions in the data dictionnary case sensitive. For example, a
> column name would be identified as totalToDate instead of TOTALTODATE
> . The main reason for that is to convert attributes (coming from classes)
> from a UML design into a database with the Java notation
> (upperCaseAndLowerCase).
>
> Thanks.
Received on Wed Aug 22 2001 - 02:24:42 CDT