Re: must table names be upper case

Technically, you can create a table with a lower-case name. You must enclose the table name in double-quotes:

SQL> CREATE TABLE "x" AS SELECT * FROM EMP;

SQL> DESC X ERROR:
ORA-04043: object x does not exist

13:30:31 SQL> desc "x"

 Name                                      Null?    	Type
 ----------------------------------------- -----------  -------
 EMP_NAME						VARCHAR2(50)
 EMP_ID							NUMBER
 SALARY							NUMBER

To refer to the table, you must refer to in with double-quotes.

Don't know why you'd want to do this, but there is how to do it.

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 385+ Oracle tips, visit:                         <->
<->                                                      <->
<->             www.arikaplan.com                        <->
<->                                                      <->
<->             email: akaplan_at_interaccess.com           <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

On Tue, 7 Nov 2000, Peter J. Schoenster wrote:

> 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).
Received on Tue Nov 07 2000 - 13:33:43 CST