Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of triggers ?
- 26 Answers
- 59953 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 a table in a database ? : Sql dba
What are sql constraints?
How can get second highest salary in sql?
what are the drivers in mysql? : Sql dba
State some properties of relational databases?
Does sqlite need a server?
What is data definition language?
What is not in sql?
What is insert command in sql?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What is anonymous block in sql?
What are the different types of dbmss?
What is difference sql and mysql?
What is user in sql?
What is auto increment feature in sql?
