What is mutating trigger?How to avoid it??

Answer Posted / muthukumar

In trigger when selection and insertion or updation in same
table that time the MUTATING TRIGGER occurs.
U CAN AVOID THAT PROBLEM USE Autonomous transactions .

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between union and union all command?

540


What is trigger types of trigger?

548


What is rtm stands for?

575


What is the difference between python and sql?

519


Why do we use triggers?

513






What is the difference between execution of triggers and stored procedures?

548


What is sql trigger example?

535


Is inner join same as self join?

576


What is a call statement? Explain with an example.

544


What are conditional predicates?

583


What is the main difference between sql and pl/sql?

558


What is the use of index in sql?

551


what is union? : Sql dba

580


What are inner outer left and right joins in sql?

511


What does an inner join do?

554