|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
set serveroutput on;
DECLARE
tbl varchar2(32);
ts timestamp;
cnt number(10);
BEGIN
SELECT systimestamp INTO ts FROM dual;
dbms_output.put_line('Time: ' || ts);
FOR result IN (SELECT table_name FROM user_tables ORDER BY table_name)
LOOP
EXECUTE IMMEDIATE 'SELECT ''' || result.table_name || ''', count(*) FROM ' || result.table_name INTO tbl, cnt;
dbms_output.put_line(tbl || ' ' || cnt || ' rows');
END LOOP;
END;
/
|