What are the types of triggers ?
- 26 Answers
- 56417 Views
- Aspire, BirlaSoft, TCS, I also Faced
- E-Mail Answers
Answer Posted / sarat
There are 4 types of Triggers
# Row Triggers and Statement Triggers
# BEFORE and AFTER Triggers
# INSTEAD OF Triggers
# Triggers on System Events and User Events
A row trigger is fired each time the table is affected by
the triggering statement. A statement trigger is fired once
on behalf of the triggering statement.
BEFORE triggers run the trigger action before the triggering
statement is run. AFTER triggers run the trigger action
after the triggering statement is run.
INSTEAD OF triggers provide a transparent way of modifying
views that cannot be modified directly through DML
statements (INSERT, UPDATE, and DELETE).
| Is This Answer Correct ? | 14 Yes | 6 No |
Post New Answer View All Answers
What is parameter substitution in sql?
Mention what does plv msg allows you to do?
How to Declare Fixed Length String Value In PL SQL
what is online transaction processing (oltp)? : Sql dba
What are the various restrictions imposed on view in terms of dml?
Explain lock escalation? : Transact sql
What are the topics in pl sql?
What is trigger in flip flop?
What is procedure and function in sql?
How long will it take to learn pl sql?
How do I order by ascending in sql?
What do you mean by “trigger” in sql?
What is benefit of creating memory optimized table?
what is bdb (berkeleydb)? : Sql dba
What are the differences between in and exists clause?
