-
-
-
What is the usage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ?
These triggers are executes when inserting, deleting and updating operations are performed and can be used to change the default function of insert, delete or update respectively. For Eg, instead of inserting a row in a table an existing row can be updated in the same table.
-
What are the two ways to incorporate images into a oracle forms application?
Boilerplate Images Image_items
-
-
Name the two files that are created when you generate the form give the filex extension ?
INP (Source File) FRM (Executable File)
-
-
-
What is the difference between a Function Key Trigger and Key Function Trigger ?
Function key triggers are associated with individual SQL*FORMS function keysYou can attach Key function triggers to 10 keys or key sequences that normally do not perform any SQL * FORMS operations. These keys referred as key F0 through key F9.
-
What does an on-clear-block Trigger fire?
It fires just before SQL * forms the current block.
-
State the order in which these triggers are executed ?
POST-FIELD,ON-VALIDATE-FIELD,POST-CHANGE and KEY-NEXTFLD.KEY-NEXTFLD,POST-CHANGE, ON-VALIDATE-FIELD, POST-FIELD.
-
-
-
-
How do you trap the error in forms 3.0 ?
using On-Message or On-Error triggers.
-
When will ON-VALIDATE-FIELD trigger executed ?
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 valid then any further change to the value in the field will not fire the on-validate-field trigger.
-
What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger ?
When you changes the Existing value to null, the On-validate field trigger will fire post change trigger will not fire. At the time of execute-query post-change trigger will fire, on-validate field trigger will not fire.
-
When is PRE-QUERY trigger executed ?
When Execute-query or count-query Package procedures are invoked.
-
-
Oracle Forms Interview Questions
Ans