Mutation
table is the table of oracle database that has the possibilities of altering,
it will changes when dealing with triggers. Mutating table error is generally
the result of poor or bad application design.
The actual meaning of “Mutating”
is “Changing”, it a table that is presently being modified or alerted by and
delete or insert, update statements. When a trigger tries to reference a table
that is in state of changing, it is considered "mutating", and an
error rises because Oracle should never go back inconsistent data. This error
can also occurs if the trigger has statements to alter the unique or Foreign,
primary key columns of the table off which it targeted.
