Interested to Buy Any Domain ? << Click Here >> for more details...
What is mutating trigger?How to avoid it??
- 3 Answers
- 14081 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / megha bidve
Use autonomous transactions because is it we can use commit
inside the trigger.
Autonomous transactions allow you to leave the context of
the calling transaction, perform an independant
transaction, and return to the calling transaction without
affecting it's state. The autonomous transaction has no
link to the calling transaction, so only commited data can
be shared by both transactions.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
what is 'mysqld'? : Sql dba
How do I view a table in sql?
What does t sql mean?
How do I count rows in sql query?
What is dynamic query?
define join and explain different type of joins? : Sql dba
What are the types of index in sql?
What is difference between joins and union?
What is a unique key?
What is sqlite format?
explain primary keys and auto increment fields in mysql : sql dba
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
What is nosql db?
Can we rollback truncate?
What is rownum?
