What are the types of triggers ?
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
How is a PL/SQL code compiled?
What is having clause in sql?
What is pl sql architecture?
How sql query is executed?
Are subqueries better than joins?
Is id a reserved word in sql?
what is datawarehouse? : Sql dba
How would you pass hints to the sql processor?
What is union?
What are sql built in functions?
how would you get the current date in mysql? : Sql dba
What are the various levels of constraints?
i have some prob lem to tell me about my self in interview first round ...
Which sorts rows in sql?
What is the mutating table and constraining table?