Which of the following code fragments would not raise an error?
A) BEGIN
FOR i IN 1..10 LOOP
DBMS_OUTPUT.PUT_LINE(i);
END LOOP;
END;
B) BEGIN
FOR i IN 1..10 LOOP
DBMS_OUTPUT.PUT_LINE(c)
END LOOP
END;
C) BEGIN
FOR i IN 1..10
DBMS_OUTPUT.PUT_LINE(i);
END LOOP;
END;
D) BEGIN
FOR i IN 1..10 LOOP
DBMS_OUTPUT.PUT_LINE
END LOOP
END;

Question

Quizplus · Accepted Answer

A is the only code fragment that has a complete and correct syntax for a loop in PL/SQL. It initializes the loop with "FOR i IN 1..10 LOOP", prints the value of the loop counter with "DBMS_OUTPUT.PUT_LINE(i)", and ends the loop with "END LOOP;" and "END;".

B has a missing semicolon after "DBMS_OUTPUT.PUT_LINE(c)" and also does not define the variable "c".
C is missing the "LOOP" keyword after "FOR i IN 1..10".
D is missing the argument for "DBMS_OUTPUT.PUT_LINE".

Which of the Following Code Fragments Would Not Raise an Error