Savepoint
From Oracle FAQ
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 | # |