1. for loop
DECLARE
C_NUM INT :=1;
BEGIN
FOR I IN 1 .. 10 LOOP
C_NUM := C_NUM * I;
END LOOP;
DBMS_OUTPUT.PUT_LINE(C_NUM);
END;
2.while() loop.. end loop
DECLARE
C_NUM INT := 1;
I INT :=1;
BEGIN
WHILE I <= 10 LOOP
C_NUM := C_NUM * I;
I := I + 1;
END LOOP;
DBMS_OUTPUT.PUT_LINE(C_NUM);
END;
3.loop..exit when.. end loop
<pre name="code" class="sql">DECLARE
C_NUM INT := 1;
I INT :=1;
BEGIN
LOOP
C_NUM := C_NUM * I;
I := I + 1;
EXIT WHEN I > 10;
END LOOP;
DBMS_OUTPUT.PUT_LINE(C_NUM);
END;