Oracle学习笔记7

一．存储过程
1）--创建存储过程
Create or replace procedure p
Is
         Cursor c is
                Select * from emp for update;
Begin
         For v_emp in c loop
                If (v_emp.deptno = 10) then
                       Update emp set sal = sal +10 where current of c;
                Elsif (v_emp.deptno = 20) then
                       Update emp set sal = sal +20 where current of c;
                Else
Update emp set sal = sal +50 where current of c;
                End if;
         End loop;
         Commit;
End;
--调用存储过程
Exec p;            --方法一
Begin        --方法二
         P;          
End;
2）--带参数的存储过程
Create or replace procedure p
--in 调用存储过程前先赋值，out 调用存储过程时赋值，没有in/out 默认为in
         (v_a in number, v_b number, v_ret out number, v_temp in out number)
Is
Begin
         If (v_a > v_b) then