Re: SQL - Count of Rows into a table
From: Maarten Scharroo <m.scharroo_at_imn.nl>
Date: Fri, 28 Jan 2000 10:20:44 +0100
Message-ID: <86rn4q$pat$1_at_porthos.nl.uu.net>
Date: Fri, 28 Jan 2000 10:20:44 +0100
Message-ID: <86rn4q$pat$1_at_porthos.nl.uu.net>
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 - 10:20:44 CET