-
Apply Form Handlers in Existing Oracle Forms
How to apply form handlers in Oracle forms which we have already created in an application?
-
-
-
What is an SQL *FORMS ?
SQL *forms is 4GL tool for developing and executing; Oracle based interactive application.
-
-
What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?
On-validate-field trigger fires, when the field Validation status New or changed.Post-field-trigger whenever the control leaving form the field, it will fire.
-
What is the difference between a POST-FIELD trigger and a POST-CHANGE trigger ?
Post-field trigger fires whenever the control leaving from the filed.Post-change trigger fires at the time of execute-query procedure invoked or filed validation status changed.
-
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.
-
-
How can you execute the user defined triggers in forms 3.0 ?
Execute Trigger (trigger-name)
-
When does an on-lock trigger fire ?
It will fires whenever SQL * Forms would normally attempt to lock a row.
-
What is the difference between key startup and pre-form ?
Key-startup trigger fires after successful navigation into a form. Pre-form trigger fires before enter into the form.
-
What is the difference between keystartup and pre-form ?
Key-startup trigger fires after successful navigation into a form.Pre-form trigger fires before enter into the form. PACKAGE PROCEDURE & FUNCTION
-
What is a Package Procedure ?
A Package procedure is built in PL/SQL procedure.
-
What are the different types of Package Procedure ?
1. Restricted package procedure. 2. Unrestricted package procedure.
-
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 does not interfere with the basic functions of SQL * Forms it can be used in any triggers.
-
-
-
What SYNCHRONIZE procedure does ?
It synchronizes the terminal screen with the internal state of the form.
-
What are the unrestricted procedures used to change the popup screen position during run time ?
Anchor-view Resize -View Move-View.
Oracle Forms Interview Questions
Ans