PL/SQL For Loop
PL/SQL For Loop
Example 1:
DECLARE
x number:=0;
BEGIN
FOR i IN 1 .. 5
LOOP
x:= i;
DBMS_OUTPUT.PUT_LINE (' x= ' || x);
END LOOP;
END;
Example 2:
BEGIN
FOR i IN 1 .. 5
LOOP
IF i NOT IN (1,5) THEN
DBMS_OUTPUT.PUT_LINE ('i = ' || i);
END IF;
END LOOP;
END;