DECLARE

emp_salary NUMBER(8,2);

PROCEDURE adjust_salary (

emp NUMBER,

sal IN OUT NUMBER,

adjustment NUMBER

) IS

BEGIN

sal := sal + adjustment;

END;

BEGIN

SELECT salary INTO emp_salary

FROM employees

WHERE employee_id = 100;

DBMS_OUTPUT.PUT_LINE('调用之前员工100的薪水: ' || emp_salary);

adjust_salary (100, emp_salary, 1000);

DBMS_OUTPUT.PUT_LINE('调用之后员工100的薪水: ' || emp_salary);

END;

ITPub博客

PLSQL Language Reference-PL/SQL语言基础-变量赋值-作为子程序参数来赋值