Re: all table names with row counts?

Thank for your input, I've got the idea.

You probably made a typo, since I dont see 'all_tables' anywhere.

P.S. This is not pure sql solution, anyway. (I switched to SQL Navigator from
archaic SQL*Plus long time ago).

"Christopher M. Day" wrote:

> 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 - 14:17:14 CST