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 the reports view in oracle sql developer?
how to return query output in html format? : Sql dba
Why do we need a foreign key?
Show the two pl/sql cursor exceptions.
What is a clob in sql?
What are different types of indexes?
What is the difference between nvl function, ifnull function, and isnull function?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
What is scope and visibility in PL/SQL?
What is transaction control language (tcl)?
Write a unique difference between a function and a stored procedure.
What is a primary key example?
What is compound trigger?
What program will open a mdb file?
what is “go” in t-sql? : Transact sql