Re: Reading column comments

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.

You should do this instead:
SQL> select comments from dba_col_comments where table_name = 'ABC';

Bye,
TG

Dskdrv wrote:

> Question about column comments.
>
> SQL> create table abc
> 2 ( id1 int,
> 3 id2 int);
>
> SQL> comment on column abc.id1 is 'a comment';
>
> SQL> select comments from dba_col_comments where table_name = 'abc';
>
> The comment for abc.id1 is not found with the select.
> Question : Should the comment be in dba_col_comments ?
>
> Thanks
Received on Mon Dec 30 2002 - 19:01:27 CST