Tech Stuff

Oracle : Exiting out of loop early

I was working on a project recently and I came across needing a need to distribute orders to zones until certain conditions were met. I found the EXIT statement came in handy for this PL/SQL Block.

Oracle/PLSQL: Exit Statement

The syntax for the EXIT statement is:

EXIT [WHEN boolean_condition];

The EXIT statement is most commonly used to terminate LOOP statements.


Let’s take a look at an example:

   EXIT WHEN order_distribute_conditions_met();

In this example, the LOOP would terminate when the conditions are met.



Author Since: Sep 09, 2009

Related Post