RE: Count(*) each table from user

From: Charudatta Joshi <joshic_at_mahindrabt.com>
Date: Fri, 2 Jul 2004 14:33:50 +0530
Message-ID: <MHEAIPLKCACENJKNJIALMEFCCCAA.joshic@mahindrabt.com>

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.

--

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_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

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

Received on Fri Jul 02 2004 - 04:01:32 CDT

RE: Count(*) each table from user_tables