What are the types of triggers ?
Answers were Sorted based on User's Feedback
Answer / sam katwal
There are three types of Triggers
Insert Trigger
Update Trigger
Delete Trigger
One Trigger also exists
Instead of Trigger which was introducted in SQL Server 2000
Is This Answer Correct ? | 21 Yes | 24 No |
Answer / sandeep chawdekar
there are mainily 3 types of triggers
1> dml trigger
2>instead of trigger written on only view
3>system trigger
dml trigger written on table that gets fired on dml events
like
insert or delete or update operation
that trigger may fire
1>after dml event
2> before dml event these are timings for trigger firing
instead of trigger written only on view that view is not
modifiable that also gets fired
when dml event occurs
system trigger gets fired on system event like
before log off or after log on or before shutdown
this trigger may be written on
database level
schema level
Is This Answer Correct ? | 0 Yes | 4 No |
Answer / arjun singh
INSERT TRIGGER
UPDATE TRIGGER
DELETE TRIGGER
Is This Answer Correct ? | 7 Yes | 22 No |
What is database migration?
What is the difference between anonymous block and named block or stored procedure?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
What is sql key?
When do we create bitmap indexes
How to read xml file in oracle pl sql?
Can a commit statement be executed as part of a trigger?
what is sql profiler
How packaged procedures and functions are called from the following?
What is auto increment feature in sql?
Begin For j in 4403201000 .. 4403202000 Loop If mod (j, 100) = 0 then Dbms_output.put_line (j); End if; End loop; End; what will be the output of this question
How to fix oracle error ora-00942: table or view does not exist