loop back in loop

[kkpareek]

Hi,

This will be too trivial to many.

I want to loop back to the top of the loop. Seems PL/SQL has neither CONTINUE nor BREAK. What am I missing?

[vbaskar]

Hi

Why donn u look at rollback / savepoint...otherwise i couldnt think of anything immd..

[kkpareek]

Hi Vijay,

rollack / savepoint will do the rollback upto the savepoint. I do not want to rollback. I just do not want to execute remaining portion of loop and go back to beginning of loop.

Is good old GOTO & Label are the only way?

[kmesser]

loop
___The_loop_code_I_always_want_to_execute;
___if I_want_to_execute_the_rest_of_the_code then
______The_rest_of_the_code;
___end if;
end loop;