RE: Explain what is mutation and what is mutating tabl...
Mutation happens in case of triggers. A 'Mutating table' is a table which is being updated by Insert update or delete triggers.It can also be a table which is being updated when delete cascade is run.
Mutation occurs when a trigger is trying to update a row which it is using currently. To solve this either we have to use intermediate table or a view so that it can choose from one while updating the other.
RE: Explain what is mutation and what is mutating tabl...
One solution also exist:
create a row level trigger and insert/update the data and take it in collections( varray or nested table or associative array). Then write a after statement level trigger and fetch that data.
