Live ORACLE

DECLARE

 my_emp_id  NUMBER(6);

  my_job_id  VARCHAR2(10);

  my_sal     NUMBER(8,2);

  CURSOR c1 IS

    SELECT employee_id,

           job_id,

           salary

    FROM   employees

    FOR UPDATE;

BEGIN

 OPEN c1;



 LOOP

   FETCH c1 INTO my_emp_id,my_job_id,my_sal;

 

   IF my_job_id = 'SA_REP' THEN

     UPDATE employees

     SET    salary = salary * 1.02

     WHERE CURRENT OF c1;

   END IF;

 

   EXIT WHEN c1%NOTFOUND;

 END LOOP;

END;

/

Using CURRENT OF to Update the Latest Row Fetched From a Cursor