Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL Question re: loops
I think the point has been missed. I know IF/THEN, ELSIF, END IF, EXIT WHEN etc. but the question is 'is there a pl/sql statement that would allow you to 'skip' this iteration of the loop i.e. you're processing 3rd iteration and you don't want a cumbersome great IF THEN ELSE construct and you just want to be able to say forget 3 let's move onto 4 (and I know that I could code a GOTO label statement). Thanks.
Greg Akins wrote in message <034469d0.817cb0f1_at_usw-ex0105-036.remarq.com>...
>So you want to loop 10 times and only execute the code in the
>loop when the condition is false.
>
>>for i in 1..10
>>loop
>> if (some condition is not satisfied) then
>> do all the other stuff
>>end loop;
>>
>>
Received on Fri Apr 14 2000 - 00:00:00 CDT
![]() |
![]() |