EXAMPLE FOR SQL%NOTFOUND (IMPLICIT CURSORS)

begin

update employee set salary = salary*0.15 where emp_code = &emp_code;

if sql%notfound then

dbms_output.put_line('employee no . does not exist');

else

dbms_output.put_line('employee record modified successfully');

end if;

end;