 Related Questions 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 ... Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ? a. ON-INSERT b. POST-INSERT c. PRE-INSERT PRE-INSERT,ON-INSERT & POST-INSERT. Execute Trigger (trigger-name) What is the difference between restricted and unrestricted package procedure ? Restricted package procedure that affects the basic functions of SQL * Forms. It cannot used in all triggers except key triggers. Unrestricted package procedure that
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
