Re: Finding num_rows in user_tables
From: Darren Cook <dcook>
Date: 1995/10/13
Message-ID: <45l661$iaq_at_pheidippides.axion.bt.co.uk>#1/1
Date: 1995/10/13
Message-ID: <45l661$iaq_at_pheidippides.axion.bt.co.uk>#1/1
Hello there,
>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;
Received on Fri Oct 13 1995 - 00:00:00 CET