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
Do foreign keys improve performance?
What is denormalization in a database?
can a stored procedure call itself or recursive stored procedure? : Sql dba
what is a control file ? : Sql dba
How many sectors are in a partition?
how to rename an existing table in mysql? : Sql dba
Why is a primary key important?
Can I learn sql in a week?
What does trigger mean in slang?
Can we enter data in a table in design view?
What's the difference between inner join and left join?
What is int identity in sql?
What will you get by the cursor attribute sql%found?
What is sql*loader?
Can we use loop in sql?