What is SAVE POINT ?

For long transactions that contain many SQL statements, intermediate markers or savepoints can be declared which can be used to divide a transaction into smaller parts. This allows the option of later rolling back all work performed from the current point in the transaction to a declared savepoint within the transaction.

Interview Candidate
Sep 6th, 2004
3
2263

Data Access

Answer

Showing Answers 1 - 3 of 3 Answers

rampratap409
Profile Answers by rampratap409 Questions by rampratap409

Dec 5th, 2006

SavePoint: this is also a TCL command, which puts break points between DML statements so that you can rollback to any point and keeping some part of transaction in process.
example
update emp set sal = 500 + sal;
savepoint a
inser into emp values(.......);
savepoint b
delete from employees where employee_id = 102
rollback to a ;
this rollback will not save changes for last two statements and transaction of first statement will be available for commiting /rollback.