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> --