Re: all table names with row counts?

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Wed, 27 Jan 1999 19:22:30 +0000
Message-ID: <36AF6776.2A4DC10@rdbms.freeserve.co.uk>

Vadim,

The following should help (although I would prefer a PL/SQL solution)

From SQL*Plus

spool table_count.sql
select 'select count(*) '||table_name||' from '||table_name||';' spool off
@table_count.sql

Chris

Vadim Tropasko wrote:
>
> I want to perform query like this
>
> select table_name, (select count(*) from table_name) from all_tables
>
> but cannot fugure out how to build join correctly. Any ideas?
>
> No procedural solution, please.
Received on Wed Jan 27 1999 - 13:22:30 CST