Interested to Buy Any Domain ? << Click Here >> for more details...
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
Why does sql need a server?
How do you drop a trigger?
What is substitution variable?
Which version of sql do I have?
Why query optimization is needed?
How do I copy a table in sql?
Why commit is not used in triggers?
What does the base_object_type column shows in the user.triggers data dictionary view?
What is the usage of when clause in trigger?
what are the different type of sql's statements ? : Sql dba
Which kind of parameters cannot have a default value in pl sql?
Is natural join same as inner join?
The select into statement is most often used to create backup copies of tables or for archiving records?
Explain ttitle and btitle.
How is data stored in sql?
