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
what are the different tables present in mysql? : Sql dba
What does dml mean?
Are stored procedures faster than queries?
What are the different type of joins in sql?
Can we have two clustered index on a table?
What are different types of functions in sql?
Is the primary key an index?
How many sql commands are there?
Is ms sql traffic encrypted?
How do you update sql?
How to execute a stored procedure?
What do you understand by pl/sql records?
What are character functions?
What are the types of operators available in sql?
What do we need to check in database testing?
