Oracle Forms 3.0

Hide the fields for internal calculation.

An alert is window that appears in the middle of the screen overlaying a portion of the current display.

It synchronizes the terminal screen with the internal state of the form.

using On-Message or On-Error 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.

Execute Trigger (trigger-name)

the pop-up field editor

pop-up list of values

pop-up pages.

Alert

Enter Validate-data in the current validation unit.

Host (E.g. Host (sqlplus))

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.

A user exit is a subroutine which are written in programming languages using pro*C pro *Cobol , etc., that link into the SQL * forms executable.

SQL *forms is 4GL tool for developing and executing; Oracle based interactive application.

Call (E.g. Call(formname)

1. Navigational Triggers.

2. Transaction Triggers.

False

1)Block processing trigger

2)Interface event trigger

3)Message-handling trigger

4)Validation trigger

5)Navigation trigger

6)Trancation trigger

7)Query_time trigger

A Package procedure is built in PL/SQL procedure.

Erase removes an indicated global variable.

True

255 character width and 255 characters Length.