A table which is being updated is a mutating table, performing any DML operations or querying on a mutating table leads to a mutating error. This can be possible in triggers or in funtions that are used in expressions.
Above answer was rated as good by the following members: kperumal75
RE: What is mutatinig trigger? How do you avoid mutati...
when theres a deadlock within multiple DML Triggers.
ex: when a a trigger has got mutiple DML statements and if a statement A tries to modify and row which statement B had already modified hence this mutating erros occures
RE: What is mutatinig trigger? How do you avoid mutati...
The basic reason for this error is the way Oracle manages a read consistent view of data. The error is encountered when a row-level trigger accesses the same table on which it is based while executing. The table is said to be mutating.
RE: What is mutatinig trigger? How do you avoid mutati...
Say for exampleThere is a before insert row level trigger T1 on the table empInside the trigger if you give Select Count(*) from Emp then mutating table error will be raised. This is because you are trying to access the emp that is being updated by the same trigger. In the same example if you change row level to statement this error will not be raised.
RE: What is mutatinig trigger? How do you avoid mutati...
A table which is being updated is a mutating table performing any DML operations or querying on a mutating table leads to a mutating error. This can be possible in triggers or in funtions that are used in expressions.
0 
1