Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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...Received on Mon Jun 18 2001 - 11:15:56 CDT
> 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