What are the types of triggers ?
- 26 Answers
- 62179 Views
- Aspire, BirlaSoft, TCS, I also Faced
- E-Mail Answers
Answer Posted / mohit tyagi(siyana bulandshaha
Basically there are three types of triggers, but the way to
use is differ. it doesn't matter on which we are
implementing these trigger.
triggers are:-
1. Cyclic Cascading Triggers.
2. Mutating Triggers.
3. Insted Off Triggers.
we can implement all these trigger on both module i.e
1.Application
2.Database
these both module are associate with the type of
implementation i.e.
1. Insert/delete/update
2. Before/After
3. Statement level/Row level
except this theory there are various ways to represent the
sql trigger. but all have the same concept for
implementation. so never confuse in order to represent the
sql trigger.
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What is your daily office routine?
define sql insert statement ? : Sql dba
How do I remove duplicates in two columns?
what is bcp? When does it used? : Sql dba
What is the current version of sql?
how many tables will create when we create table, what are they? : Sql dba
what are the advantages of sql ? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
what are all the common sql function? : Sql dba
Is primary key clustered index?
Does group by remove duplicates?
Is inner join faster than left join?
If a cursor is open, how can we find in a pl/sql block?
Do we need to rebuild index after truncate?
