What is a 'instead of trigger'?
Answers were Sorted based on User's Feedback
Answer / swapna
We can use 'instead of triggers' for views.Using these
instead of triggers we can perform DML operations on a
complex view.In complex views we can not perform DML
operations.But using instead of triggers we can insert ,
delete,update from complex views.
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / kmbkrishnan
Instead of Trigger is also like the FOR trigger, which
are triggered at that time of Insert or update or delete.
The FOR trigger will be triggering After the
Insert / Update / Delete (DML) opreation is executed. But
the Instead of Trigger will be triggering while the DML
operation held and the DML operation is discarded.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / suresh kumar somayajula
These Triggers are used to modify the VIEW whaich can't be
modified by DML statements.
Thank you,
Suresh.
Is This Answer Correct ? | 1 Yes | 0 No |
I need a function for a train ticket reservation please answer it thanks in advance
How do you delete duplicates in sql query using rowid?
Does sql profiler affect performance?
What is the use of index in hive?
Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?
What are character functions in sql?
Is sqlexception checked or unchecked?
what is a primary key? : Sql dba
What is a mutating table and a constraining table?
Can we call procedure in select statement?
Can I learn sql in a week?
how can I make a script that can be bi-language (supports english, german)? : Sql dba