Interested to Buy Any Domain ? << Click Here >> for more details...
What is autonomous transaction?
- 6 Answers
- 11948 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / narender sharma
Autonomous Transaction is an independant transaction that
is intiated by parent transaction.It can modify data,
commit or rollback independent of the state of parent
transaction.It must be commited or rollback before it ended.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / karthik
Hi,
this is a independent transaction done irrespective f
parent transcation.
ex:
i hv a procedure for updating the rows in a table.but
wether it updates or not i need this attempt of updating
the rows to be noted in a log table so i will write that as
a autonomous transaction(of course using the pragma)and so
it will be written in log table wether or not the main
table is updated.
Note:if ur using some dml in autonomous block then u HV to
COMMIT it else this transaction wil not get commited.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / sudipta kumar dhal
Autonomous transaction is an independent transaction started by another transaction,the main transaction.it can modify data,commit or rollback independent of the parent transaction is called autonomous transaction.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
How can we view last record added to a table?
What are steps required to ENTER DATA INTO DWH?
how to see the data (in unix) using dataset in datastage?
what is normalisation?what are its uses?
How do you handle duplicate records in a database?
In the oracle version 9.3.0.5.0, what does each number shows?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
what are the advantages of running a database in NO archive log mode?
How to use "startup" command to start default instance?
How to use "in out" parameter properly?
how to delete all duplicate records from a table using subquery?
Is there an oracle sql query that aggregates multiple rows into one row?
Oracle General 
