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
Can we join tables without foreign key?
what is text? : Sql dba
What is not equal in sql?
Is sql a case sensitive language?
What is sql injection vulnerability?
What is a trigger in sql?
What is dml and ddl?
what is a cursor? : Sql dba
What does where 1/2 mean in sql?
What is interval partition?
Mention what plvcmt and plvrb does in pl/sql?
Can sql function call stored procedure?
What is the difference between sum and count in sql?
When is the explicit cursor used ?
How do you write a complex sql query?
