Which of the Following Statement Blocks Correctly Uses a Scalar

Which of the following statement blocks correctly uses a scalar variable in an assignment statement?

A) DECLARE
Order NUMBER(2) := 4;
Total_amt NUMBER(2) ;
BEGIN
Total_amt = 12;
END;
B) DECLARE
Order NUMBER(2) := 4;
Total_amt NUMBER(2) ;
BEGIN
Total_amt := 12 * order;
END;
C) DECLARE
Order NUMBER(2) := 4;
Total_amt NUMBER(2) ;
BEGIN
Order := total_amt *12;
END;
D) DECLARE
Order NUMBER(2) := 4;
Total_amt NUMBER(2) ;
BEGIN
Total_amt := total_amt *12;
END;

Correct Answer:

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Access For Free