Hi Team,
Could anyone help with formatting a query to generate INSERT statements for getting row counts of a list of tables;
The query I have is;
select 'insert into table_count '||chr(13)||' select '||owner||'.'||table_name||', count(*) from '||owner||'.'||table_name||';' ||chr(13)||'commit;'
from dba_tables
where owner in ('DATAOWNER');
I want to be able to generate a list of statements that can insert the table name and row counts into the table table_count.
Any help much appreciated.
Thnx,
jd