When the mutating error will comes? and how it will be
resolved?
- 2 Answers
- 6888 Views
- I also Faced
- E-Mail Answers
Answer Posted / chandu
when we try to dml operation on orginal table in trigger.
then the trigger was excuted but while perfoming any action
on original table it will show mutating..
to overcome the above problem we need to create a autonamous
trasaction trigger..
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
how many sql dml commands are supported by 'mysql'? : Sql dba
What is rowid in sql?
Which join is like an inner join?
Is the primary key an index?
How can we optimize a sql query?
what is a trigger in mysql? Define different types of trigger. : Sql dba
What is pls integer?
How do I view a procedure in sql?
What is localdb mssqllocaldb?
Can we use distinct and group by together?
How is sql used in oracle?
What is the difference between syntax error and runtime error?
What is sql partition?
Why do we need unique key in a table?
Enlist the characteristics of pl/sql?
