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;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17013648/viewspace-1102779/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17013648/viewspace-1102779/