Interested to Buy Any Domain ? << Click Here >> for more details...
What is the relation b/w view and trigger
- 3 Answers
- 16350 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
What is rownum and rowid?
What is the purpose of primary key?
Does db2 use sql?
Why plvtab is considered as the easiest way to access the pl/sql table?
How to execute a stored procedure?
What do you know by pl/sql cursors?
what are the types of join and explain each? : Sql dba
What is pl sql in dbms?
Can you have more than one trigger on a table?
Can unique keys be null?
Is inner join same as self join?
Which is better varchar or nvarchar?
what are dynamic queries in t-sql? : Transact sql
What is sql engine in oracle?
Can we join more than 2 tables in sql?
