Nested transaction

With reference to a database transaction, a nested transaction occurs when a new transaction is started by an instruction that is already inside an existing transaction. The new nested transaction is said to be nested within the existing transaction, hence the term.

Changes made by the nested transaction are not seen by the host transaction until the nested transaction is committed. This follows from the isolation property of transactions.