Oracle ´æ´¢¹ý³Ì

 
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 emp2 set sal*2 where current of c;
      elsif () then
         update emp2 set sal*2 where current of c;
      else
          update emp2 set sal*2 where current of c;;
      end if;
  end loop;
  commit;
end;
2¡¢Ö´ÐÐ
exec p;
--------
begin
 p;
end;
3¡¢´ø²ÎÊýµÄ´æ´¢¹ý³Ì
create or replace procedure p  
    (v_a in number,v_b number,v_ret out number,v_temp in out number)  //in ´«µÄ²ÎÊý,out´«³ö²ÎÊý
is
begin
   if(v_a>v_b) then
       v_ret:=v_a;
   else
     v_ret :=v_b;
   end if;
   v_temp:=v_temp+1;
end;
ʹÓÃ:
  declare:
    v_a number :=3;
    v_b number :=4;
    v_ret number;
    v_temp number :=5;
 begin
   p(v_a,v_b,v_ret,v_temp);
   dbms......(v_ret);
   dbmmm.....(v_temp);
 end;
Èç¹ûÓдíÎó £¬¿ÉÒÔÖ´ÐÐshow error  ÃüÁîÏÔʾ´íÎóÐÅÏ¢
4¡¢functionº¯Êý
 
  create or replace function sal_tax
     (v_sal number)
     return number;
is
    
begin
 
      if (v_sal<2000) then
         return 0.10;
      elsif (v_sal<2750) then
         return 0.15;