Triggers Are divided into 2 types:

•  Before Triggers
•  After Triggers

1. Before Triggers:

Before Triggers can be used to update or validate values of a record before they are SAVED to the database.

2. After Triggers: 

After Triggers Before Triggers can be used to ACCESS field values of the records that are the stored in the database and USE this values to make changes in other records.

Syntax:

Trigger trigger_name on Object_Name(trigger_events)

{

Code BLOCK

}

WHERE trigger_events can be comma separated list of events.

Triggers Are divided into 2 types:

1. Before Triggers:

Before Triggers can be used to update or validate values of a record before they are saved to the database.

2. After Triggers: 

After Triggers Before Triggers can be used to access field values of the records that are the stored in the database and use this values to make changes in other records.

Syntax:

Trigger trigger_name on Object_Name(trigger_events)

{

Code block

}

WHERE trigger_events can be comma separated list of events.