select statement

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:21:25 CDT