can u explain which situation automonus transaction is used
Answers were Sorted based on User's Feedback
Answer / jyotiprosad roy
1 Commit in Trigger
2 Avoid Table Mutation Trigger
3 Call of function in select stmt with DML
4 Two program units ( caller and called) with two states of
commit nature
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / santosh kumar
Autonomous transactions are independent transactions within parent transaction.
At the time of insertion and updation of records into table which has to pass validation then autonomous transactions used.
| Is This Answer Correct ? | 0 Yes | 0 No |
how to initialize applications?
can we write sql statement in Format trigger?
Can u suggest me the best institute for Oracle apps Technical in Hyderabad?
What is invoice?
types of invoices?
7 Answers BelAir Store, Convergys, Wings Biotech,
How to make Parameter as Mandatory?
What are the validations you don in .CTL file in inbound interface process?
what are the important table names in purchasing?
how many groups we can create for query?
Where we can write a PL/SQL code in report triggers?
how can we get odd numbered pages in output of a report
If we transfer the data from legacy system to oracle base tables. I want to hold the data in interface table how?