how instead of triger is helpful for mutating tables errors
handlling ?
- 2 Answers
- 9628 Views
- Oracle, I also Faced
- E-Mail Answers
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 difference between delete and truncate statement in sql? : Sql dba
What is the difference between delete and truncate commands?
What is auto increment?
How to check if a column is nullable before setting to nullable?
What does count (*) do in sql?
how would concatenate strings in mysql? : Sql dba
what is the difference between where clause and having clause? : Sql dba
Is it possible for a table to have more than one foreign key?
What is record in pl sql?
Can we enter data in a table in design view?
What is the difference between sql and t sql?
What is trigger types of trigger?
What is the difference between null value, zero, and blank space?
What are the advantages of pl sql over sql?
What is the process of copying data from table a to table b?
