PL/SQL Transactions   «Prev 


1) 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.

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.

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.