RelationalDBDesignRelationalDBDesign





PL/SQL Transactions   «Prev 

COMMIT, ROLLBACK, SAVEPOINT Code Examples

COMMIT, ROLLBACK, and SAVEPOINT code examples
1) COMMIT, ROLLBACK, and SAVEPOINT code examples
COMMIT, ROLLBACK, and SAVEPOINT code examples
2) The window shows the syntax of the SAVEPOINT command. When you execute the command you mark a point in the trasaction.
You can establish any number of SAVEPOINTs within one transaction. You can reset a SAVEPOINT to a different position by repeating the SAVEPOINT command by using the same SAVEPOINT_name.
COMMIT, ROLLBACK, and SAVEPOINT code examples
3) Here is an example of a procedure that use the COMMIT and ROLLBACk commadns to control the transaction. Without the COMMIT, the update might not-saved.
COMMIT, ROLLBACK, and SAVEPOINT code examples
4) This example builds on the previous window. I have a dded a scond updated command at the beginning of the procedure to update the price stored in the SALE_ITEM table.