What is mutating trigger?How to avoid it??
- 3 Answers
- 13006 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / surendra reddy
Mutaing error happens with triggers. It occurs because the
trigger is trying to update a row it is currently using.
The usual fix involves either use of views or temporary
tables so the database is selecting from one while updating
the other.
| Is This Answer Correct ? | 13 Yes | 4 No |
Post New Answer View All Answers
Is pl sql useful?
How many joins in sql?
What are procedures used for?
How do you update f as m and m as f from the below table testtable?
What sql does db2 use?
what are the advantages of using stored procedures? : Sql dba
how do you control the max size of a heap table? : Sql dba
What are the types of queries in sql?
What is trigger in pl sql with examples?
Can you inner join the same table?
Which kind of parameters cannot have a default value in pl sql?
What is multiple partition?
How to create a menu in sqlplus or pl/sql?
What are the different schemas objects that can be created using pl/sql?
What is sqlcommand?
