Which of the following statements is correct?
A) IF order 5
Prize = 'yes';
END IF;
B) IF order 5 THEN
Prize = 'yes';
ENDIF
C) IF order 5 THEN;
Prize = 'yes';
END IF;
D) IF order 5 THEN
Prize := 'yes';
END IF;

Question

Which of the following statements is correct?
A) IF order > 5
Prize = 'yes';
END IF;
B) IF order > 5 THEN
Prize = 'yes';
ENDIF
C) IF order > 5 THEN;
Prize = 'yes';
END IF;
D) IF order > 5 THEN
Prize := 'yes';
END IF;

Quizplus · Accepted Answer

The correct syntax for an IF statement in many programming languages, including PL/SQL, requires the use of THEN after the condition, and the assignment operator is often :=. The END IF; is correctly used to close the IF statement.

Which of the Following Statements Is Correct