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 is t sql in sql server?
what is a composite primary key ? : Sql dba
How many sql core licenses do I need?
What is the largest value that can be stored in a byte data field?
What are transaction and its controls?
What are aggregate and scalar functions?
What are the two characteristics of a primary key?
How do I audit the sql sent to the server?
What is difference between sql and excel?
How do you use collections in procedure to return the resultset?
What version is sql?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What is duration in sql profiler trace?
Explain about various levels of constraint.
