Technical Discussion :: SQL
Home > Technical Interview Q&A > SQL > Discussion
10 / 108
What is Autonomous Transaction?
Answer:
The term "automous transaction" refers to the ability of PL/SQL temporarily suspend the current transaction and begin another, fully independent transaction (which will not be rolled-back if the outer code aborts). The second transaction is known as an autonomous transaction. The autonomous transaction functions independently from the parent code.
Asked In ::
Prudvi Kumar M
13 Oct, 2019 1:07 PM
The term "automous transaction" refers to the ability of PL/SQL temporarily suspend the current transaction and begin another, fully independent transaction (which will not be rolled-back if the outer code aborts). The second transaction is known as an autonomous transaction. The autonomous transaction functions independently from the parent code.
Vijjay
7 Jan, 2021 6:52 PM
Autonomous transaction allow