CREATE OR REPLACE PROCEDURE GET_SALARY(V_DEPARTMENT_ID IN NUMBER,
V_SALARY OUT NUMBER) AS
BEGIN
SELECT NVL(SUM(SALARY), 0)
INTO V_SALARY
FROM EMPLOYEES
WHERE DEPARTMENT_ID = V_DEPARTMENT_ID;
END;
/
测试过程
DECLARE
V_DEPARTMENT_ID NUMBER;
V_SALARY NUMBER;
BEGIN
V_DEPARTMENT_ID := 2;
GET_SALARY(V_DEPARTMENT_ID, V_SALARY);
DBMS_OUTPUT.PUT_LINE(V_SALARY);
END;
/
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024