[Oracle]Iterative Processing with Loops

[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 {}