Interested to Buy Any Domain ? << Click Here >> for more details...
What is the relation b/w view and trigger
- 3 Answers
- 16471 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 to know the last executed procedure?
Are stored procedures faster than queries?
What are the uses of sysdate and user keywords?
How many sql databases can you have on one server?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
What does over partition by mean in sql?
Can we use delete in merge statement?
What are string functions in sql?
Where the sql database files are stored?
how to use like conditions? : Sql dba
Can we use join in subquery?
Should I use mbr or gpt?
Which one is better subquery or joins?
How do I write a cron which will run a sql query and mail the results to agroup?
What is primary and foreign key?
