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?
Printable View
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?
Hi
Why donn u look at rollback / savepoint...otherwise i couldnt think of anything immd..
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?
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;