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
What is the use of primary key?
what are date and time data types? : Sql dba
What is the difference between distinct and unique in sql?
Explain clause in sql?
Can sql function call stored procedure?
How do I start sql from command line?
List the different type of joins?
How to read xml file in oracle pl sql?
how many sql ddl commands are supported by 'mysql'? : Sql dba
What are the types of operators available in sql?
What is rownum and rowid?
What type of join is sql join?
What is cascade in sql?
What are the types of keys?
What does plv msg allows you to do?