Multiple choice technology databases

which of the following lines is invalid: FOR i IN 1…256 LOOP --Line 1 x := x + i ; --Line 2 i := I + 5; --Line 3 END LOOP; --Line 4

  1. line 1

  2. line 2

  3. line 3

  4. line 4
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In a numeric FOR loop in PL/SQL, the loop counter (i in this case) is implicitly declared and automatically incremented by the loop construct. Attempting to assign a new value to the loop counter (i := I + 5) is not allowed and will cause a compilation error. The loop counter is read-only within the loop body.

Keep practicing — related questions