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
Code: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;