Print out comment for a given table : Comment Table « Table « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Table
  3. Comment Table

Print out comment for a given table

  


set linesize 78
set verify off
variable tname varchar2(200)
begin
  :tname := upper('&1');
end;
/

prompt Table comments for table &1
select comments
  from user_tab_comments
 where table_name = :tname
/

prompt Column comments for table &1
select column_name, comments
  from user_col_comments
 where table_name = :tname
 order by column_name
/








Related examples in the same category

1.Add a comment on a table
2.Remove a comment from table
3.Comment on table column
4.Comment table and check user_col_comments