About Control Statements

PL/SQL has three categories of control statements:

• Conditional selection statements, which let you execute different statements for different data values.

  The conditional selection statements are IF and and CASE.

• Loop statements, which let you repeat the same statements with a series of different data values.

  The loop statements are FOR LOOP, WHILE LOOP and basic LOOP.

  The EXIT statement transfers control to the end of a loop. The CONTINUE statement exits the current iteration of a loop and transfers control to the next iteration. Both EXIT and CONTINUE have an optional WHEN clause, in which you can specify a condition.

• Sequential control statements, which allow you to go to a specified, labeled statement, or to do nothing.

  The sequential control statements are GOTO and and NULL.