Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kiran
Mutating" means "changing". A mutating table is a table
that is currently being modified by an update, delete, or
insert statement. When a trigger tries to reference a table
that is in state of flux (being changed), it is
considered "mutating", and raises an error since Oracle
should never return inconsistent data.
Another way this error can occur is if the trigger has
statements to change the primary, foreign or unique key
columns of the table off which it fires. If you must have
triggers on tables that have referential constraints, the
workaround is to enforce the referential integrity through
triggers as well.
| Is This Answer Correct ? | 36 Yes | 5 No |
Post New Answer View All Answers
Write an sql query to select all records from the table?
Is sql similar to python?
How would you reference column values before and after you have inserted and deleted triggers?
who introduced sql?
What are the different types of joins in sql?
What is nosql vs sql?
What does t sql mean?
Explain polymorphism in pl/sql.
What is data types in sql?
Can a table contain multiple foreign key’s?
What are sql constraints?
What is trigger price?
What is scope and visibility in PL/SQL?
How to run sql statements through the web interface?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
