/**********************************************************/
/* @c:\oracle\sql\describe.sql                            */
/*                                                        */
/* Owner: R.Kupcunas                                      */
/* Date:  2006-Aug-25                                     */
/*                                                        */
/*  Script to describe "all" tables...                    */
/**********************************************************/

 set feedback off
 set pagesize 0
 spool describe.rslt 

select 'describe '||owner||'.'||table_name ||';'
from dba_tables
order by owner, table_name;

spool off
set feedback on
set pagesize 55

start describe.sql
