Answer Posted / pavan_1981
A mutating table is a table that is currently being
modified by an update, delete, or insert statement. For
example, if your trigger contains a select statement or an
update statement referencing the table it is triggering off
of you will receive the error.
Another way this error can occur is if the trigger has
statements to change the primary, foreign or unique key
columns of the table the trigger is triggering off of.
| Is This Answer Correct ? | 124 Yes | 5 No |
Post New Answer View All Answers
How do you write a complex sql query?
What is denormalization in a database?
what is meant by nl2br()? : Sql dba
What is hibernate and its relation to sql?
How do you concatenate in sql?
What is the use of triggers?
How to revise and re-run the last sql command?
What is Difference Between Unique and Primary Key Constraints?
What is a heap in sql?
How does postgresql compare to "nosql"?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
What is trigger in flip flop?
Which join condition can be specified using on clause?
Why do you partition data?
How do I start sql profiler?