What is the relation b/w view and trigger
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 are records give examples?
What is the unique index?
What is natural join in sql?
What is the plv (pl/vision) package offers?
Is pl sql a programming language?
How to check if a column is nullable before setting to nullable?
Why self join is used in sql?
What is the order of sql select?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
How to run sql commands in sql*plus?
Can we use having without group by in sql?
How do you declare a variable in pl sql?
what is datawarehouse? : Sql dba
How do you write a complex sql query?
How do I run a program in pl sql?