PLSQL存储过程
封装的sql代码块
输出7788号员工涨薪前后工资
代码如下(示例):
CREATE OR REPLACE PROCEDURE P_UPDATESAL(VEMPNO IN NUMBER,
VNUM IN NUMBER) IS
VSAL NUMBER;
BEGIN
SELECT SAL
INTO VSAL
FROM EMP
WHERE EMPNO = VEMPNO;
DBMS_OUTPUT.PUT_LINE('涨薪前:' VSAL);
UPDATE EMP
SET SAL = VSAL + VNUM
WHERE EMPNO = VEMPNO;
DBMS_OUTPUT.PUT_LINE('涨薪后:'(VSAL + NUM));
COMMIT;
END;
调用过程
调用方式1:
CALL P_UPDATESAL(7788, 10)
调用方式2:
DECLARE
BEGIN
P_UPDATESAL(7788. - 100)
END