Tuesday 3 May 2016

EXAMPLE OF IMPLICIT CURSORS


Begin
update employee set salary=salary *0.15
Where emp_code = &emp_code;
if sql%found then
dbms_output.put_line('employee record modified successfully');
else  
dbms_output.put_line('employee no does not exist');
end if;
end;

No comments:

Post a Comment