SET SERVEROUTPUT ON
DECLARE
N NUMBER;
BEGIN
FOR C IN (SELECT TABLE_NAME FROM USER_TABLES) LOOP
EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM ' || C.TABLE_NAME INTO N;
IF N > 0 THEN
DBMS_OUTPUT.PUT_LINE(C.TABLE_NAME || ': ' || N);
END IF;
END LOOP;
END;
/
[実行例]
M_CODE: 100
T_FILE: 3