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 are the benefits of triggers?
How to avoid using cursors?
Are sql database names case sensitive?
what is oracle database ? : Sql dba
What is a call statement? Explain with an example.
Is null operator in sql?
Can we change the table name in sql?
What is the starting oracle error number? What is meant by forward declaration in functions?
What is dml with example?
Explain clause in sql?
Mention what plvcmt and plvrb does in pl/sql?
How do I clear the screen in sql plus?
How does sql developer connect to oracle database?
What is the clause we need to add in function body to return variable?
how to use 'mysql' to run sql statements? : Sql dba
