-
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.
-
What Enter package procedure does ?
Enter Validate-data in the current validation unit.
-
What is the difference between NAME_IN and COPY ?
Copy is package procedure and writes values into a field.Name in is a package function and returns the contents of the variable to which you apply.
-
Identify package function from the following ?
1. Error-Code 2. Break 3. Call 4. Error-text 5. Form-failure 6. Form-fatal 7. Execute-query 8. Anchor View 9. Message_code 1. Error_Code ...
-
What the PAUSE package procedure does ?
Pause suspends processing until the operator presses a function key
-
What package procedure is used for calling another form ?
Call (E.g. Call(formname)
-
What package procedure used for invoke sql *plus from sql *forms ?
Host (E.g. Host (sqlplus))
-
Error_Code is a package proecdure ?
a. True b. false False.
Oracle Forms Interview Questions
Ans