what is a trigger and types of triggers

Question Posted / bhaskar reddy

3 Answers
7569 Views
HSBC, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is a trigger and types of triggers..

Answer / satty

trigger is a set of actions that will be executed or implemented , when a defined event occur. triggering events are 1.insert, 2.update, 3.delete
triggers can be defined for a specific table and once defined then it is automatically active.
triggers are used to do a data validation and to maintain data integrity.
types of triggers:
before trigger and an after trigger.
triggers information can be stored in the sysibm.systriggers

Is This Answer Correct ?

7 Yes

0 No

what is a trigger and types of triggers..

Answer / anitha

Is This Answer Correct ?

1 Yes

0 No

what is a trigger and types of triggers..

Answer / anitha

A trigger is a set of actions that are run automatically when a specified change operation is performed on a specified table. The change operation can be an SQL INSERT, UPDATE, or DELETE statement, or an insert, update, or delete high level language statement in an application program
types of triggers.
• Before delete trigger
• Before insert trigger
• Before update trigger
• After delete trigger
• After insert trigger
• After update trigger
• Read only trigger (external trigger only)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer