How to count total number of rows from all user-tables

From: shinwar <jshinwar_at_yahoo.com>
Date: 3 Oct 2002 14:19:31 -0700
Message-ID: <77e5857.0210031319.47f28818@posting.google.com>

Hi, Oracle Gurus

Before this I have posted one question. Now, I have one more question on how to count total number rows of each user table using a single query statement. I really do not know if it can be done in a single SQL statement. Let's say. I have 100 user tables. I do not want to issue 100 SQL commands for this job.

Instead, using a single SQL which uses user_ind_columns.table_name, I like to find total number of rows of all my tables. The output should, for example, be in this format:

user-tables     total_no_of_rows
-----------     -----------------
table1             99999
table2             99999

....
....

Appreciate any of your advise. Thank you for your valuable time. Received on Thu Oct 03 2002 - 16:19:31 CDT