[ORACLE] SQL 반복문 - FOR문, WHILE문[ORACLE] SQL 반복문 - FOR문, WHILE문

WHILE문

declare
    num number :=1;
begin
   Loop
         dbms_output.put_line('while:'||num);
         num := num + 1;
         if(num>5) then
            exit;
         end if;
    end loop;
end;
/

 

FOR문

 

declare
begin
    for i in 1..5 loop
           dbms_output.put_line('for:'||i);
    end loop;
end;
/

declare
    num number :=1;
begin
    while(num <=5) loop
         dbms_output.put_line('while:'||num);
         num := num + 1;
    end loop;
end;
/