exit

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

exit [2015/09/23 20:27] (current)
Line 1: Line 1:
 +====== EXIT WHEN Statement - PL/HQL Reference ======
 +
 +EXIT WHEN statement exits the loop or block marked by the given label. If the label is not specified, EXIT leaves the innermost loop. 
 +
 +If a boolean expression is specified, and it evaluates to //true// then EXIT statement is executed, otherwise it is ignored and the execution continues from the statement following EXIT.
 +
 +**Syntax:**
 +
 +<code language=sql>​
 +EXIT [label] [WHEN boolean_expression];​
 +</​code>​
 +
 +**Example:​**
 +
 +<code language=sql>​
 +WHILE count > 0 LOOP
 +  count := count - 1;
 +  EXIT WHEN count = 0;
 +END LOOP;
 +</​code>​
 +
 +<code language=sql>​
 +<<​lbl>>​
 +WHILE 1=1 LOOP
 +  <<​lbl1>>​
 +  WHILE 1=1 LOOP
 +    EXIT lbl;
 +  END LOOP;
 +END LOOP;
 +</​code>​
 +
 +**Compatibility:​** Oracle, PostgreSQL and Netezza.