--loop循环
DECLARE
num INT :=2;
counts INT :=0;
BEGIN
LOOP
num := num*2;
counts := counts + 1;
IF (counts <= 5) THEN
dbms_output.put_line(to_char(num));
ELSE
dbms_output.put_line('counts='||to_char(counts)||',已经循环5次,可以退出了');
EXIT;--退出循环
END IF;
END loop;
END;
--while循环
DECLARE
sums INT := 0;
counts INT:=1;
BEGIN
WHILE(counts<=100) LOOP
sums := sums + counts;
counts := counts + 1;
END LOOP;
dbms_output.put_line('1-100之和是 '||to_char(sums));
END;
--for循环
DECLARE
sums INT := 0;
counts INT := 1;
BEGIN
FOR i IN 1..100 LOOP
sums := sums + counts;
counts := counts + 1;
END LOOP;
dbms_output.put_line('1-100之和是 '||to_char(sums));
END;