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