Oracle Transaction Management

Chapter 9 - Laboratory Exercise: Oracle Transaction Management

Step 9.1 - Open the text file called: Chapter_9_SQL_Transaction_Management.txt

Step 9.2 - Copy each statement in Section A and paste them into SQL*Plus at the SQL> prompt to see the effects of ROLLBACK and COMMIT. Show your work by providing screenshots of executing the SQL statements in the database along with the results.

Step 9.3 - Copy each statement in Section B and paste them into SQL*Plus at the SQL> prompt to see the effects of a SAVEPOINT. Show your work by providing screenshots of executing the SQL statements in the database along with the results.

Step 9.4 - Copy each statement in Section C and paste them into SQL*Plus at the SQL> prompt to see the effects of a SET TRANSACTION READ ONLY versus READ WRITE and naming a transaction. Show your work by providing screenshots of executing the SQL statements in the database along with the results.

Step 9.5 – Design your own named transaction containing all of the options (rollback, commit, savepoint, read only, and read write) you used in this exercise. Then execute the SQL statements in the database. Show your work by providing screenshots of executing the SQL statements in the database along with the results.