set serveroutput on
--
DECLARE
CURSOR c_trig IS
SELECT table_name
FROM tabs
WHERE 1=1
AND table_name like 'T_%'
;
v_zaehler number;
BEGIN
FOR r IN c_trig
LOOP
-- execute immediate 'TRUNCATE TABLE '||r.table_name;
execute immediate 'select count(*) from ' || r.table_name into v_zaehler;
DBMS_OUTPUT.PUT_LINE(r.table_name || ' : ' || v_zaehler);
END LOOP;
END;
/
