What is the relation b/w view and trigger
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / bmk
Both are database objects and it behaves diff.View doesn't
contain data and tied with sql.Trigger is an event,trigger
will create on table with after/before with DML operations.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / vivekanandhan
view is used to minimize the complex query of table(s), thru view we can do insert,update,delete where as trigger is an event which will execute automatically when any DML operations provided against the table.
Is This Answer Correct ? | 0 Yes | 0 No |
Write a pl/sql script to display the following series of numbers: 99,96,93……9,6,3?
What are the types of optimization?
What are some predefined exceptions in pl/sql?
What is anonymous block in sql?
Is it possible to update views?
What are the different sql languages?
What is the difference between SQL table and the PLSQL table?
Why stored procedure is faster than query?
What is the difference between inner join and left join?
In a package if we have 10 procedures or functions,How to know which will execute first?
Is it possible for a table to have more than one foreign key?
Is primary key clustered or nonclustered?