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 |
what is explain plan?
What is lookup table in sql?
Do stored procedures prevent sql injection?
what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )
Can pl sql procedure have a return statement?
What is date functions?
What are different types of sql commands?
how to select unique records from a table? : Sql dba
what is schema? : Sql dba
How do I view a view in sql?
What are the different operators available in sql?
How to return more than one value from a function?