Re: PL/SQL Question re: loops

ermm...not sure if i understand what you want to do here but is it not just as straightforward as :

for i in 1..10
 loop
   if (some condition is satisfied) then

       null;
  else

     do all the other stuff
   end if;
 end loop;

or

for i in 1..10
 loop
   if not(some condition is satisfied) then

       do all the other stuff
   end if;
 end loop;

Jeremy Ovenden <jovenden_at_hazelweb.co.uk> wrote in message news:8d4pod$dd9$1_at_gxsn.com...
> Apologies if this is a really simple question, but in the 'mock' pl/sql
> below, is there a command to skip this iteration of a loop - basically not
> quit the procedure with 'return;' nor quit the loop using 'exit;'. I am
> aware this can be done using labels but is there an alternative?
>
> for i in 1..10
> loop
> if (some condition is satisfied) then
> skip this iteration
> end if;
>
> do all the other stuff
> end loop;
>
> Mant tia
>
> cheers
> jeremy - jovenden_at_hazelweb.co.uk
>
>
>
>
Received on Thu Apr 13 2000 - 00:00:00 CDT