What is mutating table?

Answer Posted / pavan_1981

A mutating table is a table that is currently being
modified by an update, delete, or insert statement. For
example, if your trigger contains a select statement or an
update statement referencing the table it is triggering off
of you will receive the error.
Another way this error can occur is if the trigger has
statements to change the primary, foreign or unique key
columns of the table the trigger is triggering off of.

Is This Answer Correct ?    124 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I remove sql developer from windows 10?

480


what is view? : Sql dba

544


How can one get sql*loader to commit only at the end of the load file? : aql loader

542


Inline the values in PL/SQL, what does it mean.?

609


Can a procedure in a package be overloaded?

517






What is error ora-12154: tns:could not resolve the connect identifier specified?

567


which operator is used in query for pattern matching? : Sql dba

528


Differentiate pl/sql and sql?

547


How do I delete a trigger?

515


What is the difference between function and procedure in pl/sql?

510


How to select unique records from a table?

547


How to Execute a Package in PL/SQL.?

555


What is mutating error?

489


how to analyze tables with 'mysqlcheck'? : Sql dba

524


Could you please provide oca (oracle 10g) dumps for my certification ?

4483