What is mutating table?

Answer Posted / gopal

Mutatation of table is a state of table when in
before /after update trigger table tries to update the same
table.As the call of update also calls same trigger then
the trigger will be called infinite times. then the table
will be mutating

Is This Answer Correct ?    43 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How much does sql cost?

734


Is natural join same as inner join?

677


How can the performance of a trigger be improved?

774


How do I view an execution plan in sql?

711


what is myisam? : Sql dba

758






What is the starting oracle error number?

754


What is gpt format?

697


What is the difference between stored procedure and view?

736


Does execute immediate commit?

927


Which sorts rows in sql?

770


What is sql keyword?

755


What is data modelling in sql?

710


What has stored procedures in sql?

779


What are the different types of triggers?

774


What is the source code of a program?

707