Interested to Buy Any Domain ? << Click Here >> for more details...
how instead of triger is helpful for mutating tables errors
handlling ?
- 2 Answers
- 10640 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 a view? : Sql dba
Which sorts rows in sql?
What is rtm in testing?
Can %notfound return null after a fetch?
Can you skip header records while loading? : aql loader
Why truncate is used in sql?
List the different type of joins?
What are the set operators in sql?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What are the various restrictions imposed on view in terms of dml?
what is bcp? When does it used? : Sql dba
Why do we use triggers?
What is the current version of postgresql?
What is output spooling in sql*plus?
What is rtm stands for?
