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

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

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

A.
PL/SQL variable

B.
Form item

C.
global variable

D.
system variable

E.
parameter

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.
Note:

PL/SQL’s data types correspond with SQL’s column types, making it easy to interchange PL/SQL
variables with data inside a table.



Leave a Reply 0

Your email address will not be published. Required fields are marked *