What does the INSTEAD OF trigger do?
Answers were Sorted based on User's Feedback
Answer / vani
Instead of triggers are the procedures that execute in
place of Data Manipulation language (DML)statement on a
table.
for example, if i have INSTEAD-OF-UPDATE Trigger on
TableA,and i execute an update statement on that table,the
code in the INSTEAD-OF-TRIGGER will be executed instead of
the update statement that I executed.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / s.vanitha
The INSTEAD OF triggers execute instead
of the original data modification. INSTEAD OF trigger are
allowed for both tables and views.
Is This Answer Correct ? | 0 Yes | 3 No |
Answer / apparao akki
None of the above answers are correct..
The Main objective of INSTEAD OF TRIGGERS is.. To handling
the complexity of View.,i.e; to manipulating the
non-updateable views(the views that have created by many
tables with help of joins, Group by operators or set operator's)
if u need more .. contact on my mail:
apparao.akki@oracle.com
Is This Answer Correct ? | 0 Yes | 3 No |
Why do we use sql limitations? Which constraints can we use while making a database in sql?
How do you troubleshoot SQL Server if its running very slow?
What is resource governor in sql server?
Can you give an example of Stored Procedure?
What is compression - row-level and page-level compression?
What is the default order of an order by clause?
To find second largest salary in Employee table
What is BCP? When does it used in sql server 2012?
0 Answers TryTechnicals Pvt Ltd,
What is the difference between a primary key and a unique key? Are they the same?
What is a non equi join?
Explain what are the authentication modes in sql server?
How to create a new schema in a database?