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

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;