Interested to Buy Any Domain ? << Click Here >> for more details...
how instead of triger is helpful for mutating tables errors
handlling ?
- 2 Answers
- 10740 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
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What are the types of queries in sql?
How many commands are there in sql?
State few characteristics of pl/sql?
What is sap sql anywhere?
What is package in pl sql?
Why coalesce is used in sql?
How do you clear the screen in sql?
Which one is better subquery or joins?
How many primary keys can a table have?
Can we group by two columns in sql?
What is trigger and stored procedure in sql?
How do I copy a table in sql?
Is sql pronounced sequel or sql?
