--
--  showcountalltables.sql
--
--  Tables - Count number of rows for each table in the current schema/login
--
--  Usage: @showcountalltables
--
set pagesize 0
spool showcountalltables.ddl
select 'select rpad('''||table_name||''',35) as TableName ,count(*) as count from '||table_name||';' from user_tables;
spool off
start showcountalltables.ddl
set pagesize 20