CREATE OR REPLACE PROCEDURE fangfa
(job_j varchar2,con_c out NUmBER,sal_s out NUmBER
)
IS
BEGIN
SELECT SUM(sal), COUNT(*) INTO con_c, sal_s
FROM emp WHERE job=job_j;
EXCEPTION
WHEN NO_DATA_FOUND THEN
DBMS_OUTPUT.PUT_LINE('你需要的数据不存在!');
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(SQLCODE||'---'||SQLERRM);
END fangfa;
--创建函数
DECLARE
V_num NUMBER;
V_sum NUMBER(8, 2);
BEGIN
fangfa('SALESMAN', v_sum,v_num);
DBMS_OUTPUT.PUT_LINE('SALESMAN部门工资总和:'||v_sum||',人数:'||v_num);
END;
--调用函数
转载于:https://www.cnblogs.com/hyx0920/p/7234673.html