Re: SELECT Statement help required

From: Gary Assa <gsa_at_panix.com>
Date: 1997/07/24
Message-ID: <5r7mu0$kn@panix.com>#1/1

>I'm trying to write a SELECT statement which will return the
>number of rows in each of a set of tables selected by owner
>from DBA_TABLES.
>

select 'select count(*) from '||table_name||';' from dba_tables;

spool this out to a file, and then execute that file. set term off and heading off so you don't get extra crap in the output.

-- 
                     ------------------------------------
If you have a condom and sunscreen SPF 15 or greater, than it's safe to look at
                     http://www.panix.com/~gsa/index.html

Received on Thu Jul 24 1997 - 00:00:00 CDT