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
Show the cursor attributes of pl/sql.
Is primary key a clustered index?
Is there a 64 bit version of ssms?
What is set transaction?
Is inner join faster than left join?
Does pl/sql support create command?
Is oracle sql free?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What does sign mean sql?
How to pronounce postgresql?
What is dynamic query?
How do I create a sql database?
What is sql mysql pl sql oracle?
what are the disadvantages of mysql? : Sql dba
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba