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!

how to take the count(*) corresponding to each table in one schema

686765Jun 5 2009 — edited Jun 16 2009

Hi All,

could anyone please tell me the, how can i take the count(*) for all the tables in one schema along with the corresponding table name.
I want to select the table_name from user_tables and count of the rows of that table.

Thanks
Abhinav

This post has been answered by Pierre Forstmann on Jun 5 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 14 2009

Added on Jun 5 2009

#general-database-discussions

7 comments

579 views