Four loops in Oracle (GOTO, For, While, Loop)

Four loops in Oracle (GOTO, For, While, Loop)

[SQL] DECLARE x number; BEGIN x: = 9; <repeat_loop> -- cyclic point x: = X-1; DBMS_OUTPUT.PUT_LINE (X); IF X> 0 THEN GOTO repeat_loop; -- when the value of x is less than 9, go to repeat_loop end if; END;/FOR Loop usage in ORACLE [SQL] DECLARE X number; -- DECLARE the variable BEGIN x: = 1; -- give the initial value for x in reverse 1 .. 10 LOOP -- reverse from large to small DBMS_OUTPUT.PUT_LINE ('Internal: x =' | x); end loop; DBMS_OUTPUT.PUT_LINE ('end loop: x = '| X ); -- x = 1 END;/The while loop usage in ORACLE [SQL] DECLARE x number; BEGIN x: = 0; WHILE x <9 LOOP x: = x + 1; DBMS_OUTPUT.PUT_LINE ('internal: x = '| x); end loop; DBMS_OUTPUT.PUT_LINE ('external: x =' | x); END; /LOOP usage in ORACLE [SQL] DECLARE x number; BEGIN x: = 0; LOOP x: = x + 1; EXIT WHEN x> 9; DBMS_OUTPUT.PUT_LINE ('Internal: x = '| x); end loop; DBMS_OUTPUT.PUT_LINE ('outer: x =' | x); END ;/