Procedure and function programming in PL/SQL

Procedure and function programming in PL/SQL

Procedure: Stored procedure eg: create or replace procedure p -- here is the difference with 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; command for executing the process: exec p; begin p end; stored procedure with parameters; create or replace procedure p -- in indicates that the out parameter is passed in, (v_a in number, v_ B number, v_ret out number, v_temp in out number) is beginif (v_a> v_ B) thenv_ret: =