Why the EXIT WHEN statement used in PL/SQL?

1.	Why the EXIT WHEN statement used in PL/SQL?
Answer» The EXIT WHEN statement has a condition under the WHEN clause. The statement acts like NULL before the condition is TRUE. The following is the syntax: EXIT WHEN condition; Here is an example: DECLARE val NUMBER(2) := 2; BEGIN WHILE val < 10 LOOP dbms_output.put_line ('VALUE = ' \|\| val); val := val + 1; EXIT WHEN val = 5; END LOOP; END; / The output: Value = 2 Value = 3 Value = 4

Answer»

The EXIT WHEN statement has a condition under the WHEN clause. The statement acts like NULL before the condition is TRUE.

The following is the syntax:

EXIT WHEN condition;

Here is an example:

DECLARE val NUMBER(2) := 2; BEGIN WHILE val < 10 LOOP dbms_output.put_line ('VALUE = ' || val); val := val + 1; EXIT WHEN val = 5; END LOOP; END; /

The output:

Value = 2 Value = 3 Value = 4

Discussion