PL/SQL Rollback to Savepoint
Oracle PL/SQL Rollback to savepoint Example
UPDATE emp_test e SET e.sal = 9000 WHERE e.ename = 'JONES'; SAVEPOINT jones_sal; UPDATE emp_test e SET e.sal = 8000 WHERE e.ename = 'FORD'; SAVEPOINT ford_sal; SELECT SUM(sal) FROM emp_test ; ROLLBACK TO SAVEPOINT jones_sal; UPDATE emp_test e SET e.sal = 11000 WHERE e.ename = 'KING'; COMMIT;