Diff. types of triggers..

Answer Posted / k. a. purushotham

Basically there are three types of triggers,

Row and statement triggers
Before and after triggers
Insteadof triggers

Possible combination of these triggers
Before row trigger
After row trigger
Before statement trigger
After statement trigger

Instead of trigger is mainly for a view.
if we want to write a trigger in such a way that the
trigger action is to be on underlying base tables of a view,
when an DML statement (insert,update,delete)is issued

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we need jdbc driver?

670


How does jdbc work?

689


When does the result for an sql statement return null?

713


What does executeupdate return in java?

747


Which is better jpa or jdbc?

710


If you are given a choice to implement the code to either insert a record or update if already exist, which approach will you follow ?

788


What is the use of statement in jdbc?

695


What is the use of JDBC DriverManager class?

778


What is JDBC Connection isolation levels?

781


What is drivermanager in jdbc?

752


Is jdbc an api?

820


Why do we use jdbc?

708


What is the latest version of JDBC? What are the new features added in that?

762


How many types of jdbc drivers are there?

762


What is @entity in java?

735