文章分类:数据库
- 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;
- /
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;
- /
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;
- /
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;
- /
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;
- /
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;
- /
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;
/
copy from : http://wyyl00.javaeye.com/blog/547441