What are the types of triggers ?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / wgk

26 Answers
60848 Views
Aspire, BirlaSoft, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are the types of triggers ?..

Answer / mani

2 types
1. instead of trigger
2.After trigger

Is This Answer Correct ?

3 Yes

2 No

What are the types of triggers ?..

Answer / krish

triggers of 4 types
1.row & statement triggers
2.before & after triggers
3.instead of triggers
4.trigger on system event & user event

Is This Answer Correct ?

1 Yes

0 No

What are the types of triggers ?..

Answer / banu

INSTEAD OF triggers
AFTER triggers
CLR triggers

Is This Answer Correct ?

1 Yes

0 No

What are the types of triggers ?..

Answer / vijay

12 types of trigger

SATEMENT LEVEL TRIGGER
1.before insert
2.before update
3.before delete
4.after insert
5.after update
6.after delete

ROW LEVEL TRIGGER
7.before insert
8.before update
9.before delete
10.after insert
11.after update
12.after delete

Is This Answer Correct ?

1 Yes

0 No

What are the types of triggers ?..

Answer / ismail

Trigger are 3 types.

1. DML trigger
2. Instead-of trigger
3. System trigger

Is This Answer Correct ?

1 Yes

1 No

What are the types of triggers ?..

Answer / shobh raj

there are mainly five types of triggers
1 DDL trigger
2 DML trigger
3 instead of trigger
4 system event
5 user event

Is This Answer Correct ?

0 Yes

0 No

What are the types of triggers ?..

Answer / manoj kumar jena

Triggers are broadly 5types in datadase.
1.Row level trigger
2.Statement level Trigger
3.Before trigger
4.After Trigger
5.Instead Trigger

Is This Answer Correct ?

0 Yes

0 No

What are the types of triggers ?..

Answer / pranee

four types of triggers generally
row level triggers
statement level triggers
after triggers
before triggers

Is This Answer Correct ?

0 Yes

0 No

What are the types of triggers ?..

Answer / nitin

There is
1)DML trigger: with before/after,for each row/for statement,and for 3 types of DML operation.
2)Instead of trigger.
3)Database level trigger: Triggers on DDL statement.
4)System level trigger.

Is This Answer Correct ?

0 Yes

0 No

What are the types of triggers ?..

Answer / chakri

row and statement trigger
before and ofter trigger
instead off trigger
system event and user event trigger

Is This Answer Correct ?

0 Yes

1 No

Post New Answer