Re: must table names be upper case

Hi,

Try using this:

create table TableName ("CoLuMn" number);

SQL> desc tablename;

 Name                            Null?    Type
 ------------------------------- -------- ----
 CoLuMn                                   NUMBER

Gyula

Sultan Syed wrote:
>
> Hai,
> Oracle always store the objects names in
> upper case.
> Can we say Oracle slightly case sensitive?
>
> Sultan Syed
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: 07 November, 2000 11:07 PM
>
> > Hi,
> >
> > Whenever I create a table Oracle converts column names to upper
> > case. Is their a setting I can change to avoid this?
> >
> > Thanks,
> >
> > Peter
> >
> > ---------------------------
> > "Reality is that which, when you stop believing in it, doesn't go
> > away".
> > -- Philip K. Dick
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Peter J. Schoenster
> > INET: peter_at_schoenster.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sultan Syed
> INET: ssyed_at_fine.co.ae
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Nov 13 2000 - 03:34:39 CST