Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Count rows from multiple tables using SQL only

449298Aug 5 2005 — edited May 20 2013

Hi, I know this has probably been answered before, but I couldn't find the answer anywhere. Please help.

I'd like count(*) [rows] for all tables in database using SQL only - no PL/SQL

The result should be something like:
Table RowCount
DBA_TABLES 1000
DBA_USERS 50

etc.
Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 17 2013

Added on Aug 5 2005

#general-database-discussions

15 comments

13,780 views