Re: Select statement

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 12 Jun 2001 20:35:06 +0200
Message-ID: <tico2rsbiun799@beta-news.demon.nl>

"Luis Fernandes" <lfernandes_at_gruposumol.pt> wrote in message news:3b26318c.24258632_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..
>
> lfernandes_at_gruposumol.pt

in sql*plus
break on report
compute count of table_name on report
select table_name from dba_tables

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Jun 12 2001 - 13:35:06 CDT