PL/SQL中的procedure和function編程

PL/SQL中的procedure和function編程 

procedure:預存程序eg: create or replace procedure p --這兒是和plsql的區別iscursor cisselect * from emp2 for update;--v_temp c%rowtype; begin for v_temp in cloopif(v_temp.sal< 2000) thenupdate emp2 set sal=sal*2 where current of c ;elsif(v_temp.sal = 5000) thendelete 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 beginif(v_a > v_b) thenv_ret :=