What is mutating trigger?How to avoid it??
Answer Posted / muthukumar
In trigger when selection and insertion or updation in same
table that time the MUTATING TRIGGER occurs.
U CAN AVOID THAT PROBLEM USE Autonomous transactions .
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
how to run 'mysql' commands from a batch file? : Sql dba
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
what is isam? : Sql dba
What is schema in sql example?
Give the order of sql select?
What are types of indexes in sql?
What is the use of double ampersand (&&) in sql queries? Give an example
What is on delete set null?
What is a scalar value in sql?
Name three sql operations that perform a sort.
How do I run a sql script?
Explain the difference between drop and truncate commands in sql?
what is the difference between char_length and length? : Sql dba
what is the difference between a web-garden and a web-farm? : Sql dba
how to concatenate two character strings? : Sql dba