How many types of database triggers can be specified on a
table ? What are they ?
Answer Posted / nilesh
There are 2 types of triggers as per the execution goes
they are ROW LEVEL and STATEMENT LEVEL TRIGGERS
Then as per action triggers can be executed for three
actions as INSERT, UPDATE and DELETE
and trigger can also be executed before the action or after
the action . So with this we can have 12 diffrent triggers
they are: (6 Row level, 6 statement level)
ROW LEVEL
AFTER INSERT , BEFORE INSERT (2 Nos.)
AFTER UPDATE , BEFORE UPDATE (2 Nos.)
AFTER DELETE , BEFORE DELETE (2 Nos.)
STATEMENT LEVEL
AFTER INSERT , BEFORE INSERT (2 Nos.)
AFTER UPDATE , BEFORE UPDATE (2 Nos.)
AFTER DELETE , BEFORE DELETE (2 Nos.)
Is This Answer Correct ? | 17 Yes | 4 No |
Post New Answer View All Answers
How do I edit a stored procedure?
Which one is better sql or oracle?
Is it mandatory for the primary key to be given a value when a new record is inserted?
Can instead of triggers be used to fire once for each statement on a view?
When is a declare statement required?
Explain the purpose of %type and %rowtype data types with the example?
How do you delete data from a table?
how to rename an existing table in mysql? : Sql dba
What are the advantages of sql? Explain
how to create a new table in mysql? : Sql dba
What is varray in pl sql?
what is a table in a database ? : Sql dba
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What is Histogram?
What is asqueryable?