What are the types of triggers ?
- 26 Answers
- 56514 Views
- Aspire, BirlaSoft, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is sql profiling in oracle?
Why do we use cursors?
how to shutdown mysql server? : Sql dba
what is the syntax used for partition in tsql? : Transact sql
how to extract a unit value from a date and time? : Sql dba
Which normal form is best?
What is a sql instance vs database?
Where is all the data on the internet stored?
What is informix sql?
How can we store rows in PL/SQL using array?
What is clustered index in sql?
how is exception handling handled in mysql? : Sql dba
Can we write ddl statements in functions?
What are character functions in sql?
What are the different types of dbmss?
