Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / bernard raj
It is independent transaction.It will executes with out
interfering the parent transaction.
An autonomous transaction is an independent transaction started by another transaction, the main transaction. Autonomous transactions let you suspend the main transaction, do SQL operations, commit or roll back those operations, then resume the main transaction.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How does the on-delete-cascade statement work?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What happens if recursive calls get out of control?
How to retrieve the count of updated rows?
What happens if you set the sga too low in oracle?
How to update a table row with a record?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Why do we use bulk collect in oracle?
What is logical backup in oracle?
What is a cursor variable?
What do you mean by redo log file mirroring?
Explain the characteristics of oracle dba?
How to use subqueries in the from clause in oracle?
What are the types of trigger in oracle?
How to delete an existing row from a table in oracle?
