What is mutating trigger?How to avoid it??
- 3 Answers
- 13004 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
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
What are the different set operators available in sql?
Which certification is best for sql?
What is sql key?
how do you know the version of your mysql server? : Sql dba
Is it possible to include an insert statement on the same table to which the trigger is assigned?
Mention what plvcmt and plvrb does in pl/sql?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
How many types of keys are there in sql?
how to write date and time literals? : Sql dba
What are the three pl sql block types?
What is pivot query?
What is constant in pl sql?
How do you select unique values in sql?
What is the use of <> sql?
Does truncate release storage space?
