|
|
FULL A - Z Oracle Function Library (formerly named "Morgan's Library")
Term: SAVEPOINT
Definition: SAVEPOINT [NAME] Example Usage: In the example below, SAVEPOINT A is set at the start of the transaction. A row is inserted into the TEST table. Another SAVEPOINT B is set just after the first insert. Now a second row is inserted into the TEST table. The transaction has to be rolled back to exclude the second insert. A rollback to savepoint B would undo the change done after savepoint B. SQL> SAVEPOINT A Related Links: |
Home | Search | Code Library | Sponsors | Privacy | Terms of Use | Contact Us | © 2003 - 2024 psoug.org |