File indexing completed on 2024-04-06 12:03:11
0001 set serveroutput on;
0002
0003 DECLARE
0004 tbl varchar2(32);
0005 ts timestamp;
0006 cnt number(10);
0007
0008 BEGIN
0009 SELECT systimestamp INTO ts FROM dual;
0010 dbms_output.put_line('Time: ' || ts);
0011 FOR result IN (SELECT table_name FROM user_tables ORDER BY table_name)
0012 LOOP
0013 EXECUTE IMMEDIATE 'SELECT ''' || result.table_name || ''', count(*) FROM ' || result.table_name INTO tbl, cnt;
0014 dbms_output.put_line(tbl || ' ' || cnt || ' rows');
0015 END LOOP;
0016 END;
0017 /
