SQL> SET SERVEROUTPUT ON
SQL> DELETE t;

1 row deleted

SQL> INSERT INTO t VALUES(1);

1 row inserted

SQL> SELECT * FROM t;

                                      A
---------------------------------------
                                      1

SQL> DECLARE
  2      CURSOR c IS SELECT * FROM t ORDER BY a;
  3      i INTEGER;
  4  BEGIN
  5  
  6      OPEN c;
  7      UPDATE t SET a = 2;
  8      FETCH c INTO i;
  9      CLOSE c;
 10      dbms_output.put_line(i);
 11  
 12      OPEN c;
 13      FETCH c INTO i;
 14      CLOSE c;
 15      dbms_output.put_line(i);
 16      COMMIT;
 17  END;
 18  /

1
2

PL/SQL procedure successfully completed

SQL> SELECT * FROM t;

                                      A
---------------------------------------
                                      2

SQL>