Parameter and Keyword Description:
An unconditional EXIT statement (i.e., one without a WHEN clause) exits the present loop instantly. The Execution resumes with the statement following the loop.
This identifies the loop to be exit. You can exit not only the preent loop but any enclosing labeled loop.
This is an expression which yields the Boolean value TRUE, FALSE, or NULL. It is computed with each iteration of the loop in which the EXIT WHEN statement appear. If the expression yields TRUE, then the present loop (or the loop labeled by label_name) is exited instantly.