What Are The Different Types Of Triggers?

1.	What Are The Different Types Of Triggers?
Answer» There are FOLLOWING TWO types of triggers: Database triggers are executed implicitly whenever a Data Manipulation Language (DML) statement is carried out on a database table or a Data Definition Language (DDL) statement, such as CREATE OR ALTER, is performed on the database. They may also be executed when a USER or database event occurs, such as a user logs on or a database is shutdown. APPLICATION triggers are executed implicitly whenever a DML event takes place within an application, such as WHEN_NEW_FORM_INSTANCE in the Oracle FORMS application. There are following two types of triggers:

Answer»

There are FOLLOWING TWO types of triggers:

Database triggers are executed implicitly whenever a Data Manipulation Language (DML) statement is carried out on a database table or a Data Definition Language (DDL) statement, such as CREATE OR ALTER, is performed on the database. They may also be executed when a USER or database event occurs, such as a user logs on or a database is shutdown.
APPLICATION triggers are executed implicitly whenever a DML event takes place within an application, such as WHEN_NEW_FORM_INSTANCE in the Oracle FORMS application.

There are following two types of triggers:

Discussion