PL/SQL PROGRAM FOR TO DELETE RECORDS USING PROCEDURE.

PL/SQL PROGRAM FOR TO DELETE RECORDS USING PROCEDURE. 


create or replace procedure prcupdate(id in number,nam in varchar2) is 
row employ%rowtype;
begin 
dbms_output.put_line(' Before Updation');
select * into row from employ where empid=id;
dbms_output.put_line('EMP ID : '||row.empid||' EMPNAME : '||row.empname);
update employ set empname=nam where empid=id;
COMMIT;
dbms_output.put_line('Updated Record');
select * into row from employ where empid=id;
dbms_output.put_line('EMP ID : '||row.empid||' EMPNAME : '||row.empname);
end;