| Oracle PL/SQL Tutorial » PL SQL Statements » Loop |
| 22. 3. 2. Simple Loops | |
A simple loop runs until you explicitly end the loop. The syntax for a simple loop is as follows: | |
| |
To end the loop, you use either an EXIT or EXIT WHEN statement. | |
The EXIT statement ends a loop immediately. | |
EXIT WHEN statement ends a loop when a specified condition occurs. |
| 22. 3. Loop | ||||
| 22. 3. 1. | Loops | |||
| 22. 3. 2. | Simple Loops | |||
| 22. 3. 3. | LOOP END LOOP | |||
| 22. 3. 4. | Count up by hundreds until we get an error | |||
| 22. 3. 5. | The EXIT WHEN statement can appear anywhere in the loop code. | |||
| 22. 3. 6. | Exit a LOOP | |||
| 22. 3. 7. | EXIT a LOOP for a certain condition | |||
| 22. 3. 8. | Nested loops: Loop inside of a Loop | |||
| 22. 3. 9. | Exiting from Nested Loops | |||
| 22. 3. 10. | Using Labels and EXIT Statements with Loops | |||
| 22. 3. 11. | Creating a REPEAT...UNTIL Loop | |||
| 22. 3. 12. | Use LOOP to insert data to a table | |||
| 22. 3. 13. | Fetch Cursor data in LOOP | |||
| 22. 3. 14. | A SQL Replacement for Regular Loops | |||
| 22. 3. 15. | Named loop block | |||