Try
select comments from dba_col_comments where table_name = 'ABC';
"Dskdrv" <dskdrv_at_cs.com> wrote in message
news:20021230184451.08041.00000396_at_mb-fw.news.cs.com...
> 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:04:26 CST
