Friday 27 April 2012

Display table and column comments


set pages 50000
set null 'No Comments'
 
tti 'Table Comments'
col comments format a29 wrap word
 
select * from user_tab_comments;
 
tti 'Column Comments'
col comments format a18 wrap word
break on table_name skip 1
select * from user_col_comments;
clear break
 
set null ''
set pages 23

No comments:

Post a Comment