12 types of trigger SATEMENT LEVEL TRIGGER 1.before insert 2.before

What are the types of triggers ?

Question Posted / vijay

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

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1171

Can a view be mutating? If yes, then how?

1028

explain normalization concept? : Sql dba

1053

Does truncate free space?

1018

Can we create a trigger on view?

901

How do we use distinct statement? What is its use?

1037

what is dbms? : Sql dba

1002

What is crud diagram?

952

What is the main reason behind using an index?

1019

what are the nonstandard string types? : Sql dba

1144

What is clause in sql?

1116

What does := mean in pl sql?

1047

What is difference between db2 and sql?

1007

What is the difference between a subquery and a join?

1114

Is id a reserved word in sql?

1151