Re: Calling all the SQL Guru's

set pagesize 0;
spool count.sql;
select 'select count(*), ''' || owner || '^' || table_name || ''' from '||owner||'.'|| table_name||' union ' from all_tables where owner not in ('SYS', 'SYSTEM')
spool off;

You will then have to edit 'count.sql' to change the word 'Union' on the last like to a ';'

--
hth,

John
For your GUI Oracle needs, try EZSQL!
www.ezsql.net


Sent via Deja.com
http://www.deja.com/