[Oracle]Iterative Processing with Loops

The Simple Loop
語法結構
Loop
EXECUTABLE_STATEMENTS
END LOOP;
THE WHILE LOOP
語法結構
WHILE CONDITION
LOOP
EXECUTABLE_STATEMENTS
END LOOP;

The Numeric FOR Loop
語法結構
FOR LOOP_COUNTER IN 1 .. 10
LOOP
EXECUTABLE_STATEMENTS
END LOOP;

FOR LOOP_COUNTER IN REVERSE 10 .. 1
LOOP
EXECUTABLE_STATEMENTS
END LOOP;

The Cursor FOR Loop
FOR RECORD IN {}