Oracle PL/SQL/System Tables Views/dba tab comments

Query dba_tab_comments

 
SQL>
SQL>
SQL> set linesize 10078
SQL> set verify off
SQL>
SQL> variable tname varchar2(200)
SQL> begin
  2    :tname := upper("&1");
  3  end;
  4  /
Enter value for 1:
PL/SQL procedure successfully completed.
SQL> column comments format a75 heading "Comments" word_wrapped
SQL>
SQL> prompt Table comments for table &1
Enter value for 1:
Table comments for table
SQL> select comments
  2    from dba_tab_comments
  3   where table_name = :tname
  4  /
no rows selected
SQL>
SQL> column column_name format a20 heading "Column Name" word_wrapped
SQL> column comments format a55 heading "Comments" word_wrapped
SQL>
SQL> prompt
SQL> prompt Column comments for table &1
Enter value for 1:
Column comments for table
SQL> select column_name, comments
  2    from dba_col_comments
  3   where table_name = :tname
  4   order by column_name
  5  /
no rows selected
SQL>
SQL> --