Interested to Buy Any Domain ? << Click Here >> for more details...
What is the relation b/w view and trigger
- 3 Answers
- 16531 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 ? | 31 Yes | 1 No |
Post New Answer View All Answers
How do I partition in sql?
What is a temp table?
How do you rename a table in sql?
Why do we use sqlite?
How do temporal tables work?
What is having clause in sql?
What is the best sql course?
What is posting?
What is sqlca in powerbuilder?
what is offset-fetch filter in tsql? : Transact sql
What is dialect in sql?
Mention what does the hierarchical profiler does?
Can we use views in stored procedure?
Which is the correct statement about truncate and delete?
What is the need of merge statement?
