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 the use of sql trace?
what happens if you no create privilege in a database? : Sql dba
Does inner join remove duplicates?
how to use in conditions? : Sql dba
Which query operators in sql is used for pattern matching?
Define implicit and explicit cursors.
What is a composite primary key?
Can we insert in sql function?
Can you rollback after commit?
Can two tables have same primary key?
What is the use of %rowtype?
What is difference between primary and secondary key?
Does execute immediate commit?
What is offset in sql query?
What are the operators in sql?