DBA_TAB_COMMENTS
Comments on all tables and views in the database
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (30) | Yes | Owner of the object |
TABLE_NAME | VARCHAR2 | (30) | Yes | Name of the object |
TABLE_TYPE | VARCHAR2 | (11) | Type of the object | |
COMMENTS | VARCHAR2 | (4000) | Comment on the object |
Usage:
CURSOR cur_comment(c_name in dba_tables.table_name%type
, c_owner in dba_objects.owner%type)
is select comments
from dba_tab_comments
where owner = c_owner
and table_name = c_name
and (table_type = 'TABLE'
OR table_type = 'VIEW');