Which type of variable must be declared before it is used in a trigger?

The correct answer is A. PL/SQL variable. PL/SQL is the language used in Forms triggers and program units. PL/SQL lets you declare variables and constants, then use them in SQL and procedural statements anywhere an expression can be used. You must declare a constant or variable before referencing it in any other…

Triggers

Question

Options

APL/SQL variable
BForm item
Cglobal variable
Dsystem variable
Eparameter

How the community answered

(40 responses)

A
85% (34)
B
3% (1)
C
5% (2)
D
8% (3)

Explanation

PL/SQL is the language used in Forms triggers and program units. PL/SQL lets you declare variables and constants, then use them in SQL and procedural statements anywhere an expression can be used. You must declare a constant or variable before referencing it in any other statements. Variables can have any SQL datatype, such as CHAR, DATE, or NUMBER, or a PL/SQL-only datatype, such as BOOLEAN orPLS_INTEGER. PL/SQL's data types correspond with SQL's column types, making it easy to interchange PL/SQL variables with data inside a table.

Topics

#PL/SQL variables#variable declaration#global variables#system variables

Community Discussion

No community discussion yet for this question.

Full 1Z0-151 Practice