Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Reading column comments

Re: Reading column comments

From: Frank <fbortel_at_home.nl>
Date: Tue, 31 Dec 2002 16:26:50 +0100
Message-ID: <3E11B73A.7060206@home.nl>


Thomas Gaines wrote:
> As with almost all Oracle dictionary tables, the names of column
> names, object names, etc. are capitalized when then go the
> dictionary, even if you refer to them uncapitalized.
>

Unless specified within quotes at creation time. SQL> create table "Emp" (col1 number);

Table created.

SQL> desc emp
ERROR:
ORA-04043: object emp does not exist

SQL> desc Emp
ERROR:
ORA-04043: object Emp does not exist

SQL> desc "Emp"

  Name                                      Null?    Type
  ----------------------------------------- -------- -------------------

  COL1                                               NUMBER

Frank Received on Tue Dec 31 2002 - 09:26:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US