What is autonomous transaction?

Answer Posted / sohini

Autonomous transactions let you suspend the main
transaction, do SQL operations in the procedure or function
in which it has been declared, 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


Please Help Members By Posting Answers For Below Questions

How to use existing values in update statements using oracle?

538


How remove data files before opening a database?

550


What is a table in oracle?

532


What are group functions in oracle?

573


How to delete an existing row from a table in oracle?

631






Why cursor variables are easier to use than cursors?

559


How to view the data files in the current database?

582


How to use fetch statement in a loop?

545


How to create lov dynamically at runtime & attach to text field?

649


How to join two tables in a single query using oracle?

557


Why packages are used in oracle?

530


What is the disadvantage of User defind function?

1822


What is the difference between PFILE and SPFILE in Oracle?

566


how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2048


What is the difference between a hot backup and a cold backup in oracle?

559