SQL & PL/SQL

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!

how to include table names in the query

Kum KMar 10 2016 — edited Mar 14 2016

Hello,

I'm working on writing a select statement to count the number of records in each table in all the schemas in our database. I would like to display the table name and the count of the records of that table in the output. Is there any easy way instead of manually getting the table names and writing the queries to count the records?

Thanks

This post has been answered by mathguy on Mar 10 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 11 2016

Added on Mar 10 2016

11 comments

9,881 views