Query dba_tab_comments : dba_tab_comments « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. 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> --

 

Related examples in the same category