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
How will you distinguish a global variable with a local variable in pl/sql?
What does subquery mean in sql?
What is difference between pl and sql?
how to enter numeric values as hex numbers? : Sql dba
What is difference between cursor and trigger?
What is a join?
what is 'mysqlimport'? : Sql dba
What is the use of double ampersand (&&) in sql queries? Give an example
what are the join types in tsql? : Transact sql
Why do we use set serveroutput on?
Is delete faster than truncate?
Why do we use view in sql?
How do you write an index?
What does pl sql developer do?
Which is faster union or join?