Answer Posted / kiran
Mutating" means "changing". A mutating table is a table
that is currently being modified by an update, delete, or
insert statement. When a trigger tries to reference a table
that is in state of flux (being changed), it is
considered "mutating", and raises an error since Oracle
should never return inconsistent data.
Another way this error can occur is if the trigger has
statements to change the primary, foreign or unique key
columns of the table off which it fires. If you must have
triggers on tables that have referential constraints, the
workaround is to enforce the referential integrity through
triggers as well.
Is This Answer Correct ? | 36 Yes | 5 No |
Post New Answer View All Answers
What is sql engine in oracle?
How does a self join work?
What are types of joins?
Is sqlite good enough for production?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What are reports usually used for?
How do you create a unique index?
Is json a nosql?
What is the difference between explicit and implicit cursors in oracle?
Define a temp table?
What are actual parameters and formal parameters?
Why are sql stored procedures used?
What is cascade in sql?
how to increment dates by 1 in mysql? : Sql dba
What are properties of the transaction?