What does the INSTEAD OF trigger do?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we create clustered index on composite key?

604


What is the difference between the 2 operating modes of database mirroring?

670


What is BCP? When does it used in sql server 2012?

651


What is the use of commit?

648


How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

664






Do you know how to store and query spatial data?

683


Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

601


What is the default Port No on which SQL Server listens?

716


How to check table values in sql server?

611


What is sql sandbox in sql server?

712


What is the query and subquery?

701


Why we should not use triggers?

613


How to implement service broker?

605


Explain the properties of subqueries in sql server?

626


Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

658