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
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.
How to import one table back from a dump file?
What is oracle host variable?
Difference between pre-select and pre-query
What are the differences between char and varchar2 in oracle?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
What is program global area (pga) in oracle?
Explain the difference between replace() and translate() functions in oracle?
what are steps for interface? where is exchange rate defined in which table?
What happens to the current transaction if a ddl statement is executed?
How to view existing locks on the database?
What are the different editions of oracle?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
What is a trace file and how is it created in oracle?