"Continue" in plsql loop
NapsterMay 21 2007 — edited Sep 3 2010Hi,
I am trying to skip a record if some conditions match in a for loop, what is the exact keyword to use that in PL/SQL. (I wanna do this without using the lables )
e.g,
DECLARE
..
i NUMBER;
BEGIN
FOR i <10
LOOP
IF i = 5
-- I want to skip the update statement if i is equal to 5 in this example
"Continue"
END IF
UPDATE ABC ....;
END LOOP;