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
Why is pl sql needed?
What is query optimization in sql?
What is sharding in sql?
How to avoid duplicate records in a query?
what are null values? : Sql dba
What is sap sql anywhere?
Is clustered index a primary key?
How many postgresql users are there, worldwide?
What do you understand by pl/sql records?
Is drop table faster than truncate?
How do I start pl sql?
what are the differences among rownum, rank and dense_rank? : Sql dba
How do I kill a query in postgresql?
Mention what plvcmt and plvrb does in pl/sql?
What is difference between inner join and cross join?