Answer Posted / kaushik
A mutating table is a table that is currently being modified
by an UPDATE, INSERT or DELETE statement, or a table that
might need to be updated by the effects of a declarative
DELETE CASCADE referential integrity action. 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.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is a memo field?
What is a unique key and primary key and foreign key?
Why do we use procedures in sql?
Is truncate ddl or dml?
How can we solve sql error: ora-00904: invalid identifier?
How can we implement rollback or commit statement in a trigger?
Is it possible to link two groups inside a cross products after the cross products group has been created?
How many types of primary keys are there?
What are different sql data types?
how to calculate expressions with sql statements? : Sql dba
What are field types?
write an sql query to find names of employee start with 'a'? : Sql dba
What are reports usually used for?
What is sap sql anywhere?
What is difference between cursor and trigger?
