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
How do I run pl sql in sql developer?
Is pl sql a scripting language?
How do I truncate a word?
Explain how can you save or place your msg in a table?
Explain the difference in execution of triggers and stored procedures?
Can we call stored procedure in function?
What is a field in a database?
Explain correlated query work?
Can we create clustered index without primary key?
How do you know if a relationship is 2nf?
what are myisam tables? : Sql dba
How do you modify a trigger?
What is a Mapplet?
What is rownum in sql?
What are conditional predicates?
