ORDER_TOTAL is a column in the orders table with the data type and size as number (8, 2) Examine the following code: Which statement is correct about the above code?

The correct answer is B. It gives an error in line 4. A variable defined as CONSTANT cannot be referenced for %TYPE.

Configuring JDBC Data Sources

Question

ORDER_TOTAL is a column in the orders table with the data type and size as number (8, 2) Examine the following code: Which statement is correct about the above code?

Exhibit

Options

AIt gives an error in line 3
BIt gives an error in line 4
CIt gives an error in line 6
DIt executes successfully and displays the output.

How the community answered

(40 responses)

A
8% (3)
B
75% (30)
C
3% (1)
D
15% (6)

Explanation

A variable defined as CONSTANT cannot be referenced for %TYPE.

Topics

#NUMBER data type#variable declaration#%TYPE#PL/SQL precision

Community Discussion

No community discussion yet for this question.

Full 1Z0-144 Practice