Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: query

Re: query

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US