Re: select statement

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Tue, 12 Jun 2001 16:40:01 +0100
Message-ID: <992360296.5344.0.nnrp-08.c30bdde2@news.demon.co.uk>

spool /tmp/runthis.sql
select 'select count(1) from '||table_name||';' from dba_tables; spool off
@/tmp/runthis.sql

"Luis Fernandes" <lfernandes_at_gruposumol.pt> wrote in message news:3b263360.24726184_at_news.telepac.pt...
> How can i do this in Oracle?
>
> select table_name from dba_tables;
>
> and then
>
> select count(*) from ... each table resulting from first select?
>
>
> I'll appreciate your solutions..
>
>
Received on Tue Jun 12 2001 - 10:40:01 CDT