how instead of triger is helpful for mutating tables errors
handlling ?
Answer Posted / mahesh
create a view (simple view) on mutating table
write a tigger on view (define similar to table)
Know try to do dml operations on table
it will not show the mutating error
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
what is msql? : Sql dba
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
What does (+) mean in sql joins?
How would you reference column values before and after you have inserted and deleted triggers?
What is flag in sql?
Why do we need unique key in a table?
What are aggregate functions in sql?
What are the basic sql commands?
Do stored procedures prevent sql injection?
How do you optimize a stored procedure query?
What is rtm in testing?
Is sql free?
How can the performance of a trigger be improved?
What is out parameter used for eventhough return statement can also be used in pl/sql?