Which of the following lines of code is syntactically correct?
a. declare order number; departure date; begin executable statements end
b. declare order number; departure date begin executable statements end
c. declare order number(3); departure date; begin executable statements end;
d. declare order number(2); departure date; begin; executable statements end

The answer is:

c.  

DECLARE

order NUMBER(3);

departure DATE;

BEGIN

executable statements ---

END;

Explanation:

SQL Commands must close with a semicolon to be correctly parsed by the server. This is the cause why the syntax is wrong in:

A. DATE; BEGIN executable statements --- END lacks semicolon in END.

B. DECLARE order NUMBER; departure DATE lacks semicolon after DATE.

D. A. DATE; BEGIN executable statements --- END lacks semicolon in END.