OTO用法,以下是SQL源碼:
DECLARE x number;BEGIN x := 0; <> --循環點 x := x + 1; DBMS_OUTPUT.PUT_LINE(X); IF x < 9 THEN --當x的值小于9時,就goto到repeat_loop GOTO repeat_loop; END IF;END;
![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLicmbw5SY3gDNzQTZ0QGZ5EjZ1UmZilDNxUmZzQTYmFDMwMWMz8CX0JXZ252bj91Ztl2Lc52YucWbp5GZzNmLn9Gbi1yZtl2Lc9CX6MHc0RHaiojIsJye.png)
FOR循環用法,以下是SQL源碼:
DECLARE x number; --聲明變量BEGIN BEGIN x := 1; --給初值 FOR x IN REVERSE 1 .. 10 LOOP --reverse由大到小 DBMS_OUTPUT.PUT_LINE('x=' || x); END LOOP; DBMS_OUTPUT.PUT_LINE('end loop x=' || x); --x=1END;
WHILE循環用法,以下是SQL源碼:
DECLARE x number;BEGIN x := 0; WHILE x < 9 LOOP x := x + 1; DBMS_OUTPUT.PUT_LINE('x=' || x); END LOOP; DBMS_OUTPUT.PUT_LINE('end loop x=' || x);END;
LOOP循環用法,以下是SQL源碼:
DECLARE x number;BEGIN x := 0; LOOP x := x + 1; EXIT WHEN x > 9; DBMS_OUTPUT.PUT_LINE('x=' || x); END LOOP; DBMS_OUTPUT.PUT_LINE('end loop x=' || x);END;