Re: Count(*) each table from user_tables

On Fri, Jul 02, 2004 at 02:33:50PM +0530, Charudatta Joshi wrote:
>
> Hi,
>
> Here's one option, assuming you collect statistics regularly and/or you
> don't need exact row counts:
>
> SELECT table_name, num_rows FROM user_tables.
>
> Regards,
> Charu.
>
>
> -----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.

Well, I would rather not use this method as I want to do it the other way (for self-learning purposes).

Any other ideas, please?

thanks,
Mihalis.

-- 
 12:47:03 up 13 days,  1:50,  2 users,  load average: 0.00, 0.04, 0.02
----------------------------------------------------------------
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
-----------------------------------------------------------------