Interested to Buy Any Domain ? << Click Here >> for more details...
What is mutating trigger?How to avoid it??
- 3 Answers
- 13907 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
Can instead of triggers be used to fire once for each statement on a view?
What is dml with example?
Can we rename a column in the output of sql query?
What is the difference between row level and statement level trigger?
what is bdb (berkeleydb)? : Sql dba
Why does sql need a server?
Why do we need view in sql?
What is substitution variable?
What is procedure and function in sql?
How do I view tables in mysql?
what are all the different types of indexes? : Sql dba
what are the differences between require and include, include_once and require_once? : Sql dba
What is sql*loader and what is it used for? : aql loader
What are the string functions in sql?
Is primary key an index?
