Query column comments through user_col_comments : comment « Table « Oracle PL/SQL Tutorial






SQL>
SQL> create table salgrades
  2  ( grade      NUMBER(2)
  3  , lowerlimit NUMBER(6,2)
  4  , upperlimit NUMBER(6,2)
  5  , bonus      NUMBER(6,2)
  6  ) ;

Table created.

SQL>
SQL>
SQL> comment on column salgrades.bonus
  2  is     'For sales reps only';

Comment created.

SQL>
SQL>
SQL>
SQL> select comments
  2  from   user_col_comments
  3  where  table_name  = 'SALGRADES'
  4  and    column_name = 'COMM';

no rows selected

SQL>
SQL> drop table salgrades;

Table dropped.

SQL>
SQL>








6.23.comment
6.23.1.Create comment for a table
6.23.2.Add comment to a column
6.23.3.Query user_tab_comments to check the table comment
6.23.4.Query column comments through user_col_comments