O'Reilly logo

Oracle SQL Recipes: A Problem-Solution Approach by Darl Kuhn, Bob Bryla, Grant Allen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 9. Managing Transactions

A single update or insert to a database table is often part of several other updates, deletes, or inserts (DML statements) within a unit of work for a particular task. Those inserts, updates, or deletes that must all succeed to maintain the integrity of the data must occur as a database transaction. Every modern RDBMS supports the concept of transactions by encapsulating one or more DML statements and treating them as an atomic unit of work.

In addition to ensuring that the entire set of operations either succeeds or fails, a transaction also hides the visibility of the changes within a transaction from other database users who may be reading or changing the same data. Once a transaction completes, the changes are ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required