Why would the following code raise an error? IF rec_order.state = 'VA' THEN
Lv_tax_num := rec_order.sub * .06;
ELSEIF rec_order.state = 'ME' THEN
Lv_tax_num := rec_order.sub * .05;
ELSE
Lv_tax_num := rec_order.sub * .04;
END IF;
A) Semicolon after THEN is omitted
B) No space between ELSE and IF
C) ELSEIF is not a keyword
D) ":=" should be "="

Question

Quizplus · Accepted Answer

In some programming languages (such as SQL), ELSEIF is a valid keyword for handling conditional statements. However, in most programming languages (including popular ones like Java and Python), the correct syntax is either ELSE IF or ELSIF (without the second "E"). Therefore, the code as written would raise a syntax error due to the incorrect keyword.

Why Would the Following Code Raise an Error? IF Rec_order