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.

Example[edit]

DELETE FROM dept WHERE deptno = 123;
SAVEPOINT step1;

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

ROLLBACK TO SAVEPOINT step1;
COMMIT;

Also see[edit]

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 #