Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL SQL <table_name> , count(*)

Re: PL SQL <table_name> , count(*)

From: Steve M <stevemc_at_sierra.com>
Date: Wed, 26 Dec 2001 15:27:02 -0800
Message-ID: <a0dm61$hdi$1@spiney.sierra.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US