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 online transaction processing (oltp)? : Sql dba
Which type of cursor is used to execute the dml statement?
Explain the order of sql statement execution?
What is difference between joins and union?
what is an alias command? : Sql dba
What are sql functions? Describe the different types of sql functions?
Explain what is a database?
How much does sql certification cost?
What is a file delimiter?
What are character functions?
what are all different types of collation sensitivity? : Sql dba
what are the advantages of mysql in comparison to oracle? : Sql dba
What is the use of count (*) in sql?
What are the triggers associated with image items?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
