DECLARE
x number;
BEGIN
x:=0;
<<test_label>>
x:=x+1;
DBMS_OUTPUT.PUT_LINE('x='||x);
IF x<5 THEN
GOTO test_label;
END IF;
END;
/
--循环
--LOOP循环
DECLARE
x number;
BEGIN
x:=0;
LOOP
x:=x+1;
IF x > 10 THEN EXIT;
END IF;
END LOOP;
DBMS_OUTPUT.PUT_LINE('x的值为:'||x);
END;
/
另一种LOOP
DECLARE
x number;
BEGIN
x:=0;
LOOP
x:=x+1;
EXIT WHEN x > 10 ;
END LOOP;
DBMS_OUTPUT.PUT_LINE('x的值为:'||x);
END;
/
--WHILE循环
DECLARE
x number;
BEGIN
x:=0;
WHILE x<3
LOOP
x:=x+1;
END LOOP;
DBMS_OUTPUT.PUT_LINE('x的值为:'||x);
END;
/
--FOR循环
DECLARE
BEGIN
FOR i IN REVERSE 1..10 LOOP
--FOR i IN 1..10 LOOP
DBMS_OUTPUT.PUT_LINE('i='||i);
END LOOP;
END;
/
--GOTO语句
DECLARE
x number;
BEGIN
x:=0;
<<test_label>>
x:=x+1;
DBMS_OUTPUT.PUT_LINE('x='||x);
IF x<5 THEN
GOTO test_label;
END IF;
END;
/