From: Mike Morgan <mmorgan1_at_mail.tds.net>
Date: Tue, 16 Mar 1999 21:55:08 -0600
Message-ID: <7cn92p$1rl@news2.tds.net>
This ought to do the trick ....
Select owner||'.'||table_name,count(*)
From dba_tab_columns
Group by owner||'.'||table_name;
RC wrote in message <36EEBC0F.9FFC047E_at_columbia.edu>...
>Anyone know how to do a select statement to count the number of columns
>for each table(32) in your database?
Received on Tue Mar 16 1999 - 21:55:08 CST