Re: SQL - Count of Rows into a table

Hi,

I mistyped the second option it should read

Option II:

Run from the prompt:

SELECT 'INSERT INTO table_count SELECT
'||table_name||',sysdate,'||count(*)||' FROM '||table_name||';' FROM user_tables;

spool the results and run the results.....

Maarten Received on Fri Jan 28 2000 - 03:20:44 CST