Home » PL/SQL MCQs

Which of the following is TRUE while using PL/SQL Exit Loop?

46. Which of the following is TRUE while using PL/SQL Exit Loop?

1. The loop body should be initialized with a variable
2. Variables in the loop are incremented.
3. When you are ready to exit the loop, you should use the EXIT WHEN statement.
4. All of the above

Answer: D) All of the above

Explanation:

While using PL/SQL Exit Loop –

1. The loop body should be initialized with a variable
2. Variables in the loop are incremented.
3. When you are ready to exit the loop, you should use the EXIT WHEN statement.