What is Autonomous transaction in Oracle

Опубликовано: 21 Июль 2016
на канале: Ram Gupta

18,509

292

What is Autonomous transaction in Oracle.
This is very frequently asking question in Interview.

Hello Friend, in this Video You can learn how we can give the answer of Autonomous Transactions.
An autonomous transaction is available from Oracle 8i. It is a very cool, useful, unique and powerful feature in oracle.
An autonomous transaction is an independent transaction that is initiated by another transaction. It must contain at least one Structured Query Language (SQL) statement.
When an autonomous transaction is called, the original transaction (calling transaction) is temporarily suspended.
The autonomous transaction must commit or roll back before it returns control to the calling transaction.
Once changes have been made by an autonomous transaction, those changes are visible to other transactions in the database.
Autonomous transactions can be nested.
For use Autonomous Transactions feature in program we have to use
PRAGMA AUTONOMOUS_TRANSACTION Key word in Program
When to use Autonomous Transactions?
• Logging mechanism
you need to log an error to your database log table. On the other hand, you need to roll back your core transaction because of the error. And you don't want to roll back over other log entries.
• Commits and rollbacks in your database triggers
If you define a trigger as an autonomous transaction, then you can commit and/or roll back in that code.
• Software usage meter
You want to keep track of how often a program is called during an application session. This information is not dependent on, and cannot affect, the transaction being processed in the application.

Mutation Error
Using autonomous transaction we can avoid mutation error.

IF you want to share with your friend this video you can copy below block of text with link and past your friend group.
-----------------------------------------------------------------------------
What is autonomous transaction in Oracle
This is a very frequently ask Question in Interview
Please Share this video with your friends and Oracle groups and communities.
   • What is Autonomous transaction in Oracle
-----------------------------------------------------------------------------

For More video's you can use blow link.
   / rameshwargupta1

Join With us our Facebook Group for PLSQL Interview Q/A
  / 146487615764170

Join our Blogs
http://oracletemple.blogspot.in/

Watch More...

What is Parameterized Cursor in Oracle
   • What is Parameterized Cursor in Oracle

What is autonomous transaction in Oracle.
   • What is Autonomous transaction in Oracle

What are Constraints available in Oracle.
   • What are Constraints in Oracle - [ SQ...

What is Mutation Error and How to avoid mutation.
   • What is Mutation in oracle

5 Effective way to delete Duplicate rows
   • How to Delete the Duplicate Records i...

What is Difference between Delete and Truncate
   • Difference Between Delete and Truncate