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