Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL SQL <table_name> , count(*)
SQL> spool c:\a_filename.sql
SQL> select 'select count(*) ' || lower(table_name) || ' from ' ||
lower(table_name) || ';' from user_tables;
:
:
SQL> spool off
SQL> start c:\a_filename.sql
"Matt Gross" <mg_redd_at_hotmail.com_NO_SPAM> wrote in message
news:9vna6g$2fso$1_at_nwall2.odn.ne.jp...
> I would like to create a pl/sql script which gives me a list of all tables
> and then gives me a count of all rows for each table. Does anyone know
how
> to do this?
>
> Thanks,
>
> Matt
>
>
Received on Wed Dec 26 2001 - 17:27:02 CST