Re: Finding num_rows in user_tables

In article <45l661$iaq_at_pheidippides.axion.bt.co.uk> Darren Cook <dcook> writes:

> >How can I find, using just one sql statement, the table_name and the
> >number of rows within each table ?
>
> Why not try using:
>
> select table_name, count(column_name)
> from user_tab_columns
> group by table_name;

Sorry, user_tab_columns only gives you the number of columns, not rows.

--
 "Everything that can be said about Win95 has been said... The Win95 user
  interface is not nearly as good as the Mac.  Blah, blah.  It has all been
  said a thousand times." - Larry Ellison

 Alvin W. Law ........................................... Oracle Corporation
 Senior Technical Consultant ................ 300 Oracle Parkway, Box 659305
 Applications Design & Architecture ............... Redwood Shores, CA 94065
 Email: alaw_at_oracle.com ...... Voice: +1.415.506.8317 . Fax: +1.415.506.7294