What is mutating table?

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


Please Help Members By Posting Answers For Below Questions

What is the use of sql trace?

451


what happens if you no create privilege in a database? : Sql dba

506


Does inner join remove duplicates?

495


how to use in conditions? : Sql dba

484


Which query operators in sql is used for pattern matching?

520






Define implicit and explicit cursors.

610


What is a composite primary key?

561


Can we insert in sql function?

513


Can you rollback after commit?

505


Can two tables have same primary key?

511


What is the use of %rowtype?

519


What is difference between primary and secondary key?

488


Does execute immediate commit?

665


What is offset in sql query?

565


What are the operators in sql?

505