What is mutating trigger?How to avoid it??
Answer Posted / muthukumar
In trigger when selection and insertion or updation in same
table that time the MUTATING TRIGGER occurs.
U CAN AVOID THAT PROBLEM USE Autonomous transactions .
Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What is cursor status?
What is bulk compiling in pl/sql.?
What is sqlerrd?
When do we use triggers?
What is AUTH_ID and AUTH_USER in pl/sql ?
what is bdb (berkeleydb)? : Sql dba
What is the primary use of normalization?
Show code of a cursor for loop.
Can we use two order by clause in query?
What is implicit cursor in pl sql?
What are types of exception?
how do you know the version of your mysql server? : Sql dba
How can I get the number of records affected by a stored procedure?
Which tcp/ip port does sql server run?
What are transaction and its controls?