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

What are the types of triggers ?

Question Posted / vijay

26 Answers
60911 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

What is a left join?

954

Explain the savepoint statement.

1096

What is mutating sql table?

1109

What is a loop in sql?

983

what is foreign key? : Sql dba

1046

what is a trigger in mysql? : Sql dba

1146

What are the types of operators available in sql?

1060

What is sql and its types?

1185

How many triggers can be applied to a table?

1063

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1042

Define join and name different types of joins?

1008

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

1164

Is ms sql is free?

1020

How to download oracle sql developer?

1104

How many joins in sql?

1008