Live ORACLE

rem -----------------------------------------------------------------------
rem Filename:   comments.sql
rem Purpose:    Display table and column comments for the current schema
rem             Handy for getting to know the database schema
rem Author:     Frank Naude, Oracle FAQ
rem -----------------------------------------------------------------------

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

Display table and column comments for the current schema