DBA_COL_COMMENTS

Comments on columns of all tables and views

Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) Yes Name of the owner of the object
TABLE_NAME VARCHAR2 (30) Yes Name of the object
COLUMN_NAME VARCHAR2 (30) Yes Name of the column
COMMENTS VARCHAR2 (4000)   Comment on the object

Usage:

cursor cur_comments(c_column_name in varchar2
                  , c_table_name  in varchar2
                  , c_owner       in varchar2) is 
select comments
from   dba_col_comments
where  owner    = c_owner
and table_name  = c_table_name
and column_name = c_columns_name;