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
What is the difference between distinct and unique in sql?
What are the two types of periodical indexes?
How to get unique records from a table?
What is the default isolation level in sql server? : Transact sql
How can triggers be used for the table auditing?
explain mysql aggregate functions. : Sql dba
what is data integrity? : Sql dba
Why is there a need for sqlcode and sqlerrm variables?
Is sql a dbms?
Which command is used to call a stored procedure?
Is there a way to automate sql execution from the command-line, batch job or shell script?
What is before and after trigger?
What is an exception in PL/SQL? What are the two types of exceptions?
What is a null value?
What is pl/sql language case sensitive?
