Re: print table name and the number of rows in it

set head off
set verify off
set termout off
set echo off
set lines 200
spool all_tables.sql
select 'select '''||table_name||''', count(*) from '||table_name||';' from user_
tables
/
spool off
set termout on
@all_tables

give me money

jg

--


@home.com is bogus.

"That would be a tough roach to hoe." -  PGN
http://news.bbc.co.uk/2/hi/technology/4500482.stm