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. ...
No.
Latest Answer : No, we cann't use go_block in pre_field trigger ...
Key-startup trigger fires after successful navigation into a form.Pre-form trigger fires before enter into the form. PACKAGE PROCEDURE & FUNCTION
A Package procedure is built in PL/SQL 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
No.
Enter Validate-data in the current validation unit.
Erase removes an indicated global variable.
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.