Save points in Oracle can be used for partial rollbacks. For instance we write few SQL statements and don’t want all of them to be committed. We can insert a save point in between and roll back changes until that save point.
UPDATE emp_name SET salary = salary + 1000 WHERE employee_id = 100;
DELETE FROM emp_name WHERE employee_id = 130;
INSERT INTO emp_name VALUES (emp_id, emp_lastname, emp_salary);
On using rollback:
rollback to do_insert;