— tab_lst.sql
— mdw – very simple tables listing
set pause on pages 24 pause ‘Any Key>’
colu num_rows form 9999,999,999
spool tab_lst.lst
select table_name
      ,owner
      ,num_rows
from  all_tables
where table_name like upper(nvl(‘&Tab_name’,’WHOOPS’)||’%’)
and owner not in (‘SYS’,’SYSTEM’)
/
spool off
clear colu