What are the types of triggers ?
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 an intersect?
What is gpt format?
What are triggers and its types?
How many aggregate functions are available there in sql?
What is plpgsql language?
Is sql a backend?
what are the advantages of mysql in comparison to oracle? : Sql dba
How does cross join work in sql?
How do you copy a table in sql?
What is cursor in pl sql with examples?
What is sqlca in db2?
Is full outer join same as cross join?
How do you break a loop in pl sql?
What is coalesce sql?
What is the use of desc in sql?