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
Why is there a need for sqlcode and sqlerrm variables?
How do I view tables in mysql?
Can primary key be changed?
what is 'mysqladmin' in mysql? : Sql dba
What is the syntax to add a record to a table?
What is PL/SQL Records?
What does seeding a database mean?
Is it possible to link two groups inside a cross products after the cross products group has been created?
Can we use insert statement in function?
how to convert dates to character strings? : Sql dba
What is t sql in sql server?
Is natural join and inner join same?
What is the clause we need to add in function body to return variable?
How to download oracle sql developer?
How to run pl sql program in mysql?