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 |
What are some predefined exceptions in pl/sql?
How do we tune the code?
Types of optimization?
What is sql injection vulnerability?
I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...
Why join is faster than subquery?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
What are the default Oracle triggers??
Can we create non-clustured index on a clustered index ?
How show all rows in sql?
What does closing a cursor do?
What is NOCOPY?