Interested to Buy Any Domain ? << Click Here >> for more details...
What is mutating trigger?How to avoid it??
- 3 Answers
- 13716 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
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
Is full outer join same as cross join?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
How subquery works in sql?
How global cursor can be declare with dynamic trigger ?
Is sql difficult?
What is the basic form of sql query?
What are literals in sql server?
Which is better stored procedure or query?
Show the two pl/sql cursor exceptions.
Can a table contain multiple primary key’s?
What is a function in oracle pl sql?
What is the difference between unique and primary key constraints?
What type of join is sql join?
