RE: Count(*) each table from user_tables

SQL*Plus, as Lex mentioned. I prefer to think of this technique as "A DBA's good friend".

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
I said it "looked" clear - Riddick

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mihalis I. Tsoukalos Sent: Friday, July 02, 2004 6:46 AM
To: oracle-l_at_freelists.org
Subject: Re: Count(*) each table from user_tables

On Fri, Jul 02, 2004 at 12:24:12PM +0200, Lex de Haan wrote:
> well, you could of course generate a SQL*Plus script to do the work for
> you --
> something like:
> SQL> set heading off trimspool off ... off ... off ... off
> SQL> spool doit.sql
> SQL> select 'select count(*) from '||table_name||';'
> 2 from user_tables;
> SQL> spool off
> SQL> @doit
>
> Kind regards,
> Lex.
> >
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org
> > [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mihalis I. Tsoukalos
> > Sent: Friday, July 02, 2004 12:03 PM
> > To: Oracle Mailing List
> > Subject: Count(*) each table from user_tables
> >
> >
> > Dear list,
> >
> > I have the following question:
> >
> > I want to count(*) every table from users_table table using SQL.
> > I know how to do it in PL/SQL but not in SQL.
> > Can you please help me do it?
> >
> > many thanks in advance,
> > Mihalis.

Thanks for the reply.

Is this standrd SQL (if yes, which version 1999 or 2003?) or Oracle SQL?

cheers,
Mihalis.

-- 
 14:43:42 up 13 days,  3:47,  2 users,  load average: 0.32, 0.16, 0.05
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------