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 union and union all command?
how many no of table can be join in a sql query.
Can you join a table to itself?
What does sql stand for?
Can we use out parameter in function?
What are the syntax and use of the coalesce function?
Can we create clustered index without primary key?
What is the difference between a database and a relational database?
What is sap sql?
How many scalar data types are supported in pl/sql?
What are the advantages of the packages
What is the use of primary key?