Savepoint

From Oracle FAQ
Jump to: navigation, search

A savepoint is a marker or point in an transaction to which you can later roll back.

[edit] Example

DELETE FROM dept WHERE deptno = 123;
SAVEPOINT step1;

INSERT INTO dept VALUES (123, 'Editors', Oracle FAQ');
SAVEPOINT step2;

ROLLBACK TO SAVEPOINT step1;
COMMIT;

[edit] Also see

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #