Actually your English is quite good. I wouldn't have known you weren't
except for your comment. " is a quote or a double quote. ' is a single
quote or a tick.
Jim
"T. Schwickert" <schwickert_at_yahoo.com> wrote in message
news:5fcc15a8.0108212324.ac2f97_at_posting.google.com...
> 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 - 07:38:02 CDT
