PL/SQL How to user "continue" in a FOR LOOP

[anshuman]

Hi,
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.

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;
 

[debasisdas]

With the continue statement you can skip to the next iteration in a loop.

try to use the following sample code

begin  
for i in 1..3  loop    
dbms_output.put_line(’i=’||to_char(i));    
if ( i = 2 )  then       
continue;     
end if;    
dbms_output.put_line(’ Only if i is not equal to 2 ′);  
end loop;
end;
 

Note: this is a feature of Oracle 11g . So try in that version only.

[debasisdas]

You can also use the continue when statement to determine when to go to the next iteration in the loop.

begin  
for i in 1..3  loop    
dbms_output.put_line(’i=’||to_char(i));    
continue when ( i = 2 );    
dbms_output.put_line(’Only if i is not equal to 2′);  
end loop;
end;

[amitpatel66]

Hi,
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.

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;

In case if you want to try out in lower versions of oracle, then try this:

declare
begin
for i in 1..10 loop
declare
my_execp EXCEPTION;
BEGIN
IF(I = 5) THEN
RAISE my_exscep;
ELSE
UPDATE ABC....;
END IF;
EXCEPTION
WHEN my_excep THEN
dbms_output.put_line('dont update now!!');
END;
END LOOP;
END;
 

I have not tested this code. I hope this should help you out to achive your requirement!!

[skkydiver]

Hi,
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.

e.g,

 
DECLARE
..
i NUMBER;
BEGIN
 
END LOOP;
 

Have not used Continue, but the following works

 
DECLARE
..
i NUMBER;
BEGIN
 
FOR i <10
LOOP
    IF i = 5
     UPDATE ABC ....;
    END IF
END LOOP;
 

[Dave44]

Have not used Continue, but the following works

 
DECLARE
..
i NUMBER;
BEGIN
 
FOR i <10
LOOP
    IF i = 5
     UPDATE ABC ....;
    END IF
END LOOP;
 

yep i agree with you completely, keep it simple. except in this case i think he said no update if its 5 so we'd need IF i <> 5 then