Count Rows

---

set termout off echo off feed off trimspool on head off     pages 0; spool C:\temp\counts.log; set column table_name format a16; select 'SELECT '''||table_name||','',    TO_CHAR(count(*),''999,999,990'') from '||table_name||';' from user_tables; spool off; set termout on; @@C:\temp\counts.log; set termout on echo on feed on trimspool off head     on pages 40;

---