What are the types of triggers ?

Answer Posted / kumar sudeep

1. Cyclic Cascading Triggers.
2. Mutating Triggers.
3. Insted Off Triggers.

All the above with differences in areas of implementaion
difference as below:
1. Database.
2. Application.

And with ways of implementation differences as below:
1. BEFORE/AFTER.
2. Insert/Update/delete.
3. Statement level/Row level.

Is This Answer Correct ?    12 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the features of pl sql?

563


What is a memo field?

529


what are the 'mysql' command line arguments? : Sql dba

652


How is a PL/SQL code compiled?

670


How does a trigger work?

538






How to write pl sql program in mysql command prompt?

519


How do you write a complex sql query?

589


Is postgresql a nosql database?

535


How do I view tables in mysql?

543


what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

555


what does the t-sql command ident_incr does? : Transact sql

602


What is an example of translating a date into julian format?

580


Can we insert in view in sql?

568


what are date and time functions in mysql? : Sql dba

536


What is data control language?

532