♥ tugas 3 DBMS ♥

Irma Santikarama
PIS0904 30108255

SQL_3
SIMPLE LOOP

LOOP
Statement-statement;
END LOOP;


Statement For

FOR var IN [REVERSE] indeks_min .. indeks_max LOOP
Statement-statement;
END LOOP;

Ex :
Declare
x number(3);
BEGIN
X:=&berapa;
FOR i IN 1..x LOOP
if mod(i,2) = 1 then
DBMS_OUTPUT.PUT_LINE('Ini angka ' || i );
else
DBMS_OUTPUT.PUT_LINE('Ini angka ' || ‘i’ );
end if;
END LOOP;
END;
/



Statement While

WHILE kondisi LOOP
Statement-statement;
END LOOP;

Ex :
DECLARE
i NUMBER(3);
hasil NUMBER(5);
BEGIN
i:=1;
WHILE i <= 10 LOOP
hasil := i**3;
DBMS_OUTPUT.PUT_LINE(i ||' pangkat 3 = '|| hasil );
i := i + 1;
END LOOP;
END;
/



Statement Exit dan Exit When

EXIT WHEN kondisi;

IF kondisi THEN
EXIT;
END IF:

Ex :
DECLARE
total NUMBER(9);
counter NUMBER(6);
BEGIN
total := 0;
counter := 10;
LOOP
total := total + counter;
DBMS_OUTPUT.PUT_LINE(' Total: ' || total);
EXIT WHEN total > 50;
END LOOP;
DBMS_OUTPUT.PUT_LINE('Counter: ' || counter);
END;
/