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 substitution variable in pl sql?
a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.
Explain the methods used to protect source code of pl/sql.
Is it important to partition hard disk?
does sql support programming? : Sql dba
what are wild cards used in database for pattern matching ? : Sql dba
What is sqlcommand?
How to fix oracle error ora-00942: table or view does not exist
i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.
What is sql partition?
Does truncate free space?
What is mdf ldf and ndf?