Re: select statement

> He meant he wanted the number of records in each table, not the number of
> tables.

That's exactly what it does.

> spool /tmp/runthis.sql

Changed it a little to get the table_name as header for the column :

select 'select count(1) '||table_name||' from '||owner||'.'||table_name||';' from dba_tables;

> spool off
> @/tmp/runthis.sql

Rob. Received on Wed Jun 13 2001 - 06:31:40 CDT