Discussion in 'Oracle Forms and Reports' started by mist, Dec 20, 2013.
Can any one please send me the examples on triggers(all) in oracle forms
Triggers come in 3 flavors in the Forms tool : Item, Block and Form. Triggers will fire based on the EVENT in question. For a specific example of each trigger (there are several dozen) you would be better served to look them up in the tool itself. The Forms tool has, if I remember correctly, a rather helpful cue card option within the Help.
If possible detailed explanation on triggers or documents
Your response appears to indicate that you don't have access to the Forms tool. Is that correct? If so, I'm not entirely sure what you're looking for. Simply put, a trigger in a Form is a set of SQL or PL/SQL code that executes based upon an event that may happen during runtime.
You can have code fire for the form instance, changing to another form block, entering an item field, validation before insert, and so forth. While similar in concept to database triggers, they are not quite the same.