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 |
Do you know how to store and query spatial data?
How to list all dsn entries on your local machine using odbc_data_source()?
How to insert data into an existing table?
Is mysql better than sql server?
What is sql server english query?
How to Install SQL SERVER 2005 remotely?
What is key attribute?
What is the order by used for?
What is the data type of time?
How to connect to a sql server using odbc_connect()?
Can I run multiple instances of sql server 2000 at the same time on one computer?
What is microsoft sql server?