ALL_TAB_COMMENTS

Comments on tables and views accessible to the user

Columns
   ___________________________
 
   OWNER
      Owner of the object
   TABLE_NAME
      Name of the object 
   TABLE_TYPE
      Type of the object
   COMMENTS
      Comment on the object 

Related:

 DBA_ALL_TABLES         ALL_ALL_TABLES        USER_ALL_TABLES
 DBA_PART_TABLES        ALL_PART_TABLES       USER_PART_TABLES 
 DBA_TABLES             ALL_TABLES            USER_TABLES          TAB 
 DBA_TAB_COLUMNS        ALL_TAB_COLUMNS       USER_TAB_COLUMNS 
 DBA_TAB_COLS           ALL_TAB_COLS          USER_TAB_COLS 
 DBA_TAB_COL_STATISTICS ALL_TAB_COL_STATISTICS USER_TAB_COL_STATISTICS 
 DBA_TAB_COMMENTS       ALL_TAB_COMMENTS      USER_TAB_COMMENTS 
 DBA_TAB_HISTOGRAMS     ALL_TAB_HISTOGRAMS    USER_TAB_HISTOGRAMS 
 DBA_TAB_MODIFICATIONS  ALL_TAB_MODIFICATIONS USER_TAB_MODIFICATIONS 
 DBA_TAB_PARTITIONS     ALL_TAB_PARTITIONS    USER_TAB_PARTITIONS