Re: Select statement

Try running a script like
 select
 ' select count(*) , '''||owner||table_name||''' from '||owner||'.'||table_name||';'
 from dba_tables;
This will create a script for you.i.e

You can do

>spool file_name

sql>' select count(*) , '''||owner||table_name||''' from '||owner||'.'||table_name||';'
 from dba_tables;
>/
>spool off

 then run
>@file_name

At the SQL prompts
This will give you what you are looking for.

--
Ravi Alluru
Independent IS Consultant
796299 Alberta LTD
PH (403) 298-4805
Cell (403)607-8568
mailto:ravica_at_quixnet.net

"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