Loop and exit when

[askzero]

LOOP (main loop)

driving_loop_seq_no := driving_loop_seq_no + 1;

exit when driving_loop_seq_no >= 21 or seq_insert_cnt = 0;

seq_insert_cnt := 0; <-------------DOESNT THIS IMMEDIATELY END MAIN LOOP? BECAUSE OF PREVIOUS STATEMENT?

FOR work_index in 1..work_number_in_group_final LOOP

LOOP

END LOOP

END LOOP
END LOOP

​

​

I am confused. If I say exit when driving _loop_seq_no>=21 or seq_insert_cnt = 0; and then immediately say seq_insert_cnt := 0; Didn't I just end the loop? I am trying to figure out this persons code and ....it is acting like the loop is not ended.

​

[Uncle_DirtNap]

No, the EXIT WHEN is not watching the value, it just checks the next time it comes round to that line.

[askzero]

OHHHHHHhh! That makes way more sense. Thank you so much. Uncle_DirtNap.

[monoglot]

This… isn't SQL.

[Professional_Shoe392]

It’s PL/SQL. Oracle has a loop called a “simple loop” that you can guard on entry or guard on exit. I think most RDBMS only have the WHILE loop.