This query returns the table count,and the row count.

This query returns the table count,and the row count.

select tname,count(*) from tab group by tname;

select table_name,num_rows from user_tables