Which of the following code fragments tells the system to look up the data type of a database column and use it for the declared variable?
A) DECLARE
Order NUMBER(2) := 4;
Total_amt NUMBER(2);
BEGIN
--- executable code ---
END;
B) DECLARE
Order.quantity%TYPE;
Total_amt NUMBER(2);
BEGIN
--- executable code ---
END;
C) DECLARE
Order.quantity#TYPE;
Total_amt NUMBER(2);
BEGIN
--- executable code ---
END;
D) DECLARE
Order CONSTANT NUMBER(2) := 4;
Total_amt NUMBER(2);
BEGIN
--- executable code ---
END;

Question

Quizplus · Accepted Answer

The code fragment in option B uses the %TYPE attribute to declare the variable Order as having the same data type as the quantity column in the database. This is a useful feature of PL/SQL that reduces errors and increases code readability. Option A declares the data type explicitly, Option C uses an invalid syntax, and Option D declares Order as a constant rather than a variable.

Which of the Following Code Fragments Tells the System to Look