What are the types of triggers ?
Answers were Sorted based on User's Feedback
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 |
Answer / ismail
Trigger are 3 types.
1. DML trigger
2. Instead-of trigger
3. System trigger
Is This Answer Correct ? | 1 Yes | 1 No |
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 |
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 |
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 |
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 |
what is the difference between stored procedure and packaged procedure
Why is a primary key important?
When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?
2 Answers Accenture, Unisoft Infotech,
What are the benefits of triggers?
What is form and report?
What is a unique key?
How subquery works in sql?
What is difference between sql and excel?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
Do prepared statements prevent sql injection?
What are the types of variable use in pl sql?
What is a self join ?