Oracle® PL/SQL® Interactive Workbook, Second Edition

Lab 4.2 Making Use of SAVEPOINT

Lab Objectives After this Lab, you will be able to: ✓ Make Use of COMMIT, ROLLBACK, and SAVEPOINT in a PL/SQL Block

Transactions are a means to break programming code into manageable units. Grouping transactions into smaller elements is a standard practice that ensures an application will save only correct data. Initially, any application will have to connect to the database in order to access the data. It is important to point out that when a user is issuing DML statements in an application, the changes are not visible to other users until a COMMIT or ROLLBACK has been issued. Oracle guarantees a read-consistent view of the data. Until that point, all data that have been inserted or updated will be held in memory ...