sagar singh

• Jun 11th, 2006

 

When a trigger tries to access its own table, from which its fired, then the trigger is said to be mutating and table is mutating table.

Arun Arumugam

• Jul 1st, 2006

 

A table is said to be a Mutating table under the following three circumstances1) When u try to do delete, update, insert into a table through a trigger and at the same time u r trying to select the same table.2) The same applies for a view3) Apart from that, if u r deleting (delete cascade),update,insert on the parent table and doing a select in the child tableAll these happen only in a row level trigger

g_sidhu

 Profile 

• Feb 18th, 2008

 

A mutating table is a table that is currently being modified by an UPDATE, DELETE, or INSERT statement. A table is not considered mutating for STATEMENT triggers. The triggered table itself is a mutating table, as well as any table referencing it with the FOREIGN KEY constraint. This restriction prevents a row trigger from seeing an inconsistent set of data.