adspace


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What are the types of triggers ?

Question Posted / vijay

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

Is primary key always clustered index?

1101

what is schema? : Sql dba

1163

Can delete statement be rollbacked?

1065

what is collation? : Sql dba

1242

Is inner join faster than left join?

1287

How do I remove duplicates in two columns?

1202

If a cursor is open, how can we find in a pl/sql block?

1252

What is your daily office routine?

2353

what is sql server agent? : Sql dba

1189

What is the current version of postgresql?

1188

Do we need to rebuild index after truncate?

1154

What is the best sql course?

1064

what are aggregate and scalar functions? : Sql dba

1142

what are the advantages of sql ? : Sql dba

1154

Does group by remove duplicates?

1120