Title: Demonstrate the use of SAVEPOINT, ROLLBACK, and COMMIT.
Course: Database Design and Management (Oracle) (10052) > Section: Making Database Transactions

Demonstration should include a process flow that demonstrates the following, in order (with autocommit turned off):

1. Execute a transaction against the data (insert or update).
2. Execute a transaction against the data (insert or update).
3. Create SAVE POINTA.
4. Execute a transaction against the data (insert or update).
5. Execute a transaction against the data (insert or update).
6. Create SAVE POINTB.
7. Execute a transaction against the data (insert or update).
8. ROLLBACK to SAVEPOINTA.
9. Execute a transaction against the data (insert or update).
10. Execute a transaction against the data (insert or update).
11. COMMIT.
12. Run a query and validate the updates made to the data.