 Related Questions A piece of logic that is executed at or triggered by a SQL *forms event. Latest Answer : A forms trigger is a block of PL/SQL code that adds functionality to your
application. Triggers are attached to objects in your application. When a
trigger is fired, it executes the code it contains. Each trigger’s name defines
what event will ... 1. Navigational Triggers. 2. Transaction Triggers. Latest Answer : pre triggers,post triggers,when trigger,transactional trigger,validation triggers,key triggerskishor ... Function Key Key-function Key-others Key-startup Latest Answer : 1. Interface Triggers2. Navigational Triggers ... Function key triggers are associated with individual SQL*FORMS function keysYou can attach Key function triggers to 10 keys or key sequences Latest Answer : Function Key Triggers - are associated with individual Runform function keys. A function key trigger fires only when user presses the associated function key. The action defined in Function Key Trigger replaces the default action of function key. For ... using On-Message or On-Error triggers. Latest Answer : other then on-error trigger , you can use exception also in that blockwith the help of a small procedure and alert you can populate the message and with raise_form_trigger_failure transaction can be controlled. ... POST-FIELD,ON-VALIDATE-FIELD,POST-CHANGE and KEY-NEXTFLD.KEY-NEXTFLD,POST-CHANGE, ON-VALIDATE-FIELD, POST-FIELD. Latest Answer : ON-VALIDATE-FIELD -> KEY-NEXTFLD -> POST-FIELD -> POST-CHANGE ... These triggers are executes when inserting, deleting and updating operations are performed and can be used to change the default Latest Answer : hi Triggers are like stored pocedure consisting of batch of sql statements. ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS attached to the respective tables get fired when the tables gets manipulated by the query containing DML statements and checks for ... It fires when a value in a field has been changed and the field status is changed or new and the key has been pressed. If the field status is Latest Answer : on-validate field tigger will fire when ever cursor moves from that field to next field, so first key-next will fire then validate. ... A query fetched 10 records How many times does a PRE-QUERY Trigger and POST-QUERY Trigger will get executed ? PRE-QUERY fires once. POST-QUERY fires 10 times. When Execute-query or count-query Package procedures are invoked. Latest Answer : pre-query trigger fires before any execution of a query. this trigger fires only once per query. where as post query fires for each row. ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
