Issues with database and forms triggers

[Ainsley]

I am so confused to create the triggers ! can you help me to differentiate between both triggers forms triggers and database triggers.please Help me to construct the triggers at forms level and database level with somewhat examples.And when it comes into the action.

[Zecho]

Database triggers:

A database trigger is a PL/SQL program that is created for a specific table or view.The code contain some action whenever the SQL command is in the execution like - when you will go to insert some values using INSERT statement,the trigger will contain some action upon INSERT that is coded by developer.
A database trigger contains three sections

1. A triggering event
2. A trigger constraint
3. Trigger action

[Reegan]

Forms Triggers:
Forms triggers are also a collection of PL/SQL codes which is fired when an application generates any events, Like - When a user change the value of list items,etc.

So many types of triggers are available in forms :
· Key-triggers
· Navigational-triggers
· Transaction-triggers
· Message-triggers
· Error-triggers
· Query based-triggers

[opaper]

Creating database trigger :
You can create a trigger upon modification of any table or database object.

CREATE [ OR REPLACE ] TRIGGER Name_of_trigger
 GROUP group_name
 [ DEBUG { TRUE | FALSE } ]
 [ ENABLED { TRUE | FALSE } ]
 PRIORITY integer
 [ COMMENT 'desired_string_comment' ]
 { BEFORE | AFTER } { INSERT | UPDATE | DELETE | REINSERT } 
 ON DB_name.object_name
 FOR EACH { ROW | STATEMENT }
 [ WHEN condition ]
 [ DECLARE variable_declaration ]
 BEGIN
   action_of_trigger
END;