DECLARE CNT NUMBER(10):=0; TMP_CNT NUMBER(10):=0; BEGIN FOR CUR IN ( SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER='我' AND TABLE_NAME IN('tab1',...,'tab20'); ) LOOP EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM ' || CUR.TABLE_NAME || ' WHERE 类型=3' INTO TMP_CNT; CNT := CNT + TMP_CNT; END LOOP; DBMS_OUTPUT.PUT_LINE(CNT); END; /
CNT NUMBER(10):=0;
TMP_CNT NUMBER(10):=0;
BEGIN
FOR CUR IN (
SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER='我' AND TABLE_NAME IN('tab1',...,'tab20');
) LOOP
EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM ' || CUR.TABLE_NAME || ' WHERE 类型=3' INTO TMP_CNT;
CNT := CNT + TMP_CNT;
END LOOP; DBMS_OUTPUT.PUT_LINE(CNT);
END;
/