PL/SQL中的procedure和function编程

PL/SQL中的procedure和function编程

PL/SQL中的procedure和function编程 

procedure:存储过程 eg:   create or replace procedure p --这儿是和plsql的区别 is cursor c is select * from emp2 for update; --v_temp c%rowtype;   begin   for v_temp in c loop if(v_temp.sal< 2000) then update emp2 set sal=sal*2 where current of c ; elsif(v_temp.sal = 5000) then delete from emp2 where current of c; end if; end loop; commit; end;   执行过程的命令：exec p; begin p end;   带参数的存储过程； create or replace procedure p --in表示传入参数 out传出参数， (v_a in number,v_b number ,v_ret out number,v_temp in out number) is   begin if(v_a > v_b) then v_ret :=