What is the relation b/w view and trigger
- 3 Answers
- 15619 Views
- Accenture, TCS, I also Faced
- E-Mail Answers
Answer Posted / rajesh venati
View are classified in to two types.
1. Simple View
2. Complex View
==>DML Operations are not possible in complex views, because,
if u create a view more than one table or
if u create a view using group function or
if u create a view using distinct keyword etc.,
those are called complex view.
If u want perform DML Operations on Complex Views, then we
will go for Instead of Trigger.
Through the Instead of Triggers we can perform DML
Operations on a Complex View.
| Is This Answer Correct ? | 30 Yes | 1 No |
Post New Answer View All Answers
What is native sql query?
What is inner join in sql?
What is clause in sql?
Is merge a dml statement?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
What is the difference between microsoft sql and mysql?
What is the difference between the conventional and direct path loader? : aql loader
What are the qualities of 2nf?
Can there be more than one function with a similar name in a pl/sql block?
what is csv? : Sql dba
Which one is better subquery or joins?
What is a unique key?
Can you skip header records while loading? : aql loader
What is cost in sql execution plan?
what is myisam? : Sql dba
