Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PL/SQL Question re: loops

PL/SQL Question re: loops

From: Jeremy Ovenden <jovenden_at_hazelweb.co.uk>
Date: 2000/04/13
Message-ID: <8d4pod$dd9$1@gxsn.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US