Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / swapna
We can use 'instead of triggers' for views.Using these
instead of triggers we can perform DML operations on a
complex view.In complex views we can not perform DML
operations.But using instead of triggers we can insert ,
delete,update from complex views.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is the difference between instead of trigger and after trigger?
Can we delete column in sql?
How can triggers be used for the table auditing?
what are set operators in sql? : Sql dba
Mention what problem one might face while writing log information to a data-base table in pl/sql?
How do I view stored procedures?
Can you selectively load only those records that you need? : aql loader
How would you convert date into julian date format?
How to display the records between two range in Oracle SQL Plus?
Write a query to display the current date in sql?
What is nosql example?
What is difference between function and trigger?
Can I create table without primary key?
Why is there a need for sqlcode and sqlerrm variables?
What do you mean by rowid?
