View updated row in PL/SQL

[ali560045]

i have a PL/SQL Block that will update a row uisng FOR LOOP CURSOR and then should show the Updated row one at a time.

Below is the code,What i m confused/want the logic to be implemented inside the FOR LOOP to show the updated row

begin
	   for record in (select sal from emp where deptno='20')
	   LOOP
	   update emp set sal=sal + 1000 where sal=record.sal;
	   dbms_output.put_line( record.sal );
	   END LOOP;
END;

[LKBrwn_DBA]

Did you try returning it:

-- Etc --
   new_sal   NUMBER;
BEGIN
   FOR RECORD IN (SELECT empno, sal
                    FROM emp
                   WHERE deptno = '20')
   LOOP
      UPDATE    emp
            SET sal = sal + 1000
          WHERE empno = RECORD.empno
      RETURNING sal
           INTO new_sal;

      DBMS_OUTPUT.put_line (new_sal);
   END LOOP;
END;

PS: Check out the changes to the SELECT and WHERE clauses!
.