Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Reading column comments
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