If you don’t absolutely need it in a plsql script, and you are just using the information for occasional review, this simple sqlplus script would work.
Save the following in a text file: buildscript.sql
set pagesize 0
SELECT ‘select ”’ || table_name || ‘: ”, count(*) from ‘ || table_name || ‘;’ from user_tables;
In Sqlplus, run the buildscript.sql file. The script will first build a new script file and then execute the new script giving the table name and its count. Remember to enter the correct schema name and password in the connect statement.