What is mutating trigger?How to avoid it??
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 is int identity in sql?
Are stored procedures compiled?
What is the maximum rows in csv?
Explain sql data types?
what are dynamic queries in t-sql? : Transact sql
what is rdbms? : Sql dba
What is a .db file?
Why do we use function in pl sql?
what is collation? : Sql dba
What is a pl/sql block?
Show code of a cursor for loop.
Can we create clustered index without primary key?
What is the use of partition by in sql?
Why do we use set serveroutput on?
How can you select unique records from a table?