Interested to Buy Any Domain ? << Click Here >> for more details...
What is mutating trigger?How to avoid it??
- 3 Answers
- 13909 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
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
When should I use nosql database?
How to know the last executed procedure?
How do I start pl sql?
What is varchar sql?
What does rownum mean in sql?
Is primary key clustered index?
What is sql in java?
What is the difference between distinct and unique in sql?
What is sql analyzer?
What is sap sql anywhere?
how to use 'mysql' to run sql statements? : Sql dba
what are string data types? : Sql dba
What is the maximum rows in csv?
