RE: Count(*) each table from user_tables
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 2 Jul 2004 07:01:07 -0500
SQL*Plus, as Lex mentioned. I prefer to think of this technique as "A DBA's
good friend".
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx
I said it "looked" clear - Riddick
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Mihalis I. Tsoukalos
Sent: Friday, July 02, 2004 6:46 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
> > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
