Live ORACLE

DECLARE

  my_sal  employees.salary%TYPE;

   my_job  employees.job_id%TYPE;

   factor  INTEGER := 2;

   CURSOR c1 IS

     SELECT factor * salary

     FROM   employees

     WHERE  job_id = my_job;

BEGIN

  OPEN c1; -- factor initially equals 2

 

  LOOP

    FETCH c1 INTO my_sal;

   

    EXIT WHEN c1%NOTFOUND;

   

    factor := factor + 1; -- does not affect FETCH

 

  END LOOP;

 

  CLOSE c1;

END;

/

Referencing PL/SQL Variables Within Its Scope