What are the types of triggers in PL/SQL and in forms?in pl/sql, My guess is:row level, statement level,before,after,insert,update,deleteare there any triggers i missed, let me know?Thanks in advance.

Interview Candidate
Nov 16th, 2006
6
3679

Showing Answers 1 - 6 of 6 Answers

Anusha

Nov 23rd, 2006

1) Block_Processing Triggers, 2) Interface event triggers, 3) master/Detail Triggers, 4) navigational Triggers,
5) Query_time triggers, 6) Transactional Triggers 7) Validational Triggers 8) Message_handling Triggers 9)When_New_Instance Triggers

Pawan Ahuja

Dec 3rd, 2006

In forms eigth types of trigger.
1) Block_Processing Triggers, 2) Interface event triggers, 3) master/Detail Triggers, 4) navigational Triggers,
5) Query_time triggers, 6) Transactional Triggers 7) Validational Triggers 8) Message_handling Triggers 9)When_New_Instance Triggers.
In Pl/sql there are three types of triggers.
1.)DML trigger that apply on dml opertion. 2.)System event trigger 3.) instead of trigger(on view)
Regards
Pawan Ahuja