RE: Count(*) each table from user_tables

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@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.

--
 09:31:15 up 12 days, 22:35,  2 users,  load average: 0.04, 0.03, 0.06
----------------------------------------------------------------
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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


*********************************************************
Disclaimer:          

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*********************************************************
Visit us at http://www.mahindrabt.com

----------------------------------------------------------------
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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: