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 sqlite used for?
what is a unique key ? : Sql dba
What is the difference between delete and truncate commands?
How to raise user-defined exception with custom sqlerrm ?
What is a unique key?
how to delete an existing column in a table? : Sql dba
what is a trigger in mysql? : Sql dba
Why functions are used in sql?
how to enter binary numbers in sql statements? : Sql dba
What is varray in pl sql?
What is java sql driver?
What is pl sql commands?
what is dbms? : Sql dba
What is the trigger in sql?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me