Triggers In Oracle Forms:-

Trigger is a pl/sql code that gets executed whenever a event gets fired. We use triggers if we wanted to execute some business logic for any specific event.

For example : 

If we want to perform some action ‘when a button is clicked’ or ‘when a new form is opened’ or ‘double click on a specific field’ or ‘when a window is closed’ and likewise.

Triggers in form builder are categorized in three levels:

·         Form level

·         Block Level

·         Item level

 Form Level:-

A form level trigger belongs to the form and can fire due to events across the entire form.

Block Level Triggers:-

Block level trigger belongs to a block and can only fire when the current block is used.

Item level triggers:-

Item level trigger belongs to an individual items and can only fire when a particular item is activated.