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
Define union, minus, union all, intersect ?
How to rename a column in the output of sql query?
Why is sharding used?
Define join and name different types of joins?
Are dml statements autocommit?
What are field types?
Can we have two clustered index on a table?
In pl/sql, what is bulk binding, and when/how would it help performance?
What is embedded sql what are its advantages?
What will you get by the cursor attribute sql%found?
What does desc stand for?
Does sql use python?
How do you use join?
how to run 'mysql' commands from a batch file? : Sql dba
what is the difference between cluster and non cluster index? : Sql dba