Transactional processing in Oracle

Transactions are used to guarantee data consistency, which consists of a set of related DML statements that either all succeed or fail altogether.

Transactions and Locks

When performing transactional operations (DML statements), Oracle locks on the table to prevent other users from changing the structure of the table, which is very important to our users.

Commit a transaction

When the commit statement can commit a transaction, when the commit statement is executed, the transaction changes, the end of the transaction, the deletion of the savepoint, the release of the lock, and when the commit statement ends the transaction, the other session will be able to view the new data after the transaction has changed.

Fallback transaction

Before introducing a fallback transaction, let's introduce the concept and function of the savepoint (SavePoint), which is a point in the transaction that cancels a partial transaction and automatically deletes all the savepoint-defined save points when the transaction is ended. When rollback is executed, the specified point can be rolled back by specifying a savepoint.

Transactional processing in Oracle