Tables - Count number of rows for each table in the current schema/login |
-- -- 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 |