Skip to Main Content

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!

Count of all tables in a schema

BaleJan 30 2019 — edited Apr 29 2022

Hi Team,

I have a schema contain 25 tables and I would like to get every table count and with the table name.

expected results:

Table Name          Count

Table1                    2000

Table2                    3000

Table3                     4000

Table4                     5000

Can someone please help me with this.

Thank you

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 27 2022
Added on Jan 30 2019
8 comments
9,935 views