FOR LOOP
This Oracle tutorial explains how to use the FOR LOOP in Oracle with syntax and examples.
Description
In Oracle, the FOR LOOP allows you to execute code repeatedly for a fixed number of times.
Syntax
The syntax for the FOR Loop in Oracle/PLSQL is:
FOR loop_counter IN [REVERSE] lowest_number..highest_number LOOP {...statements...} END LOOP;Parameters or Arguments
- loop_counter
- The loop counter variable.
- REVERSE
- Optional. If specified, the loop counter will count in reverse.
- lowest_number
- The starting value for loop_counter.
- highest_number
- The ending value for loop_counter.
- statements
- The statements of code to execute each pass through the loop.
Note
- You would use a FOR LOOP when you want to execute the loop body a fixed number of times.
- If REVERSE is specified, then the highest_number will be the starting value for loop_counter and lowest_number will be the ending value for loop_counter.
Example
Let's look at an example of how to use a FOR LOOP in Oracle.
FOR Lcntr IN 1..20 LOOP LCalc := Lcntr * 31; END LOOP;This FOR LOOP example will loop 20 times. The counter called Lcntr will start at 1 and end at 20.
You can use the REVERSE modifier to run the FOR LOOP in reverse order. For example:
FOR Lcntr IN REVERSE 1..15 LOOP LCalc := Lcntr * 31; END LOOP;This FOR LOOP example will loop 15 times. However, because REVERSE is specified, the counter called Lcntr will start at 15 and end at 1 (in essence, looping backwards).
No. | Subject | Author | Date | Views |
---|---|---|---|---|
» | FOR LOOP | admin | 2016.05.20 | 278 |
85 | SUBSTR | admin | 2016.05.26 | 280 |
84 | CAPTCHA PLUG-IN | admin | 2016.05.27 | 305 |
83 | Access Control List (ACL) | admin | 2016.06.07 | 350 |
82 | Oracle 11g Access Control List for External Network Services | admin | 2016.06.07 | 306 |
81 | ACL 보기 | admin | 2016.06.07 | 319 |
80 | CREATE_ACL (1st STEP) | admin | 2016.06.07 | 320 |
79 | ADD_PRIVILEGE (2nd STEP) | admin | 2016.06.07 | 360 |
78 | Assign a network host to Access Control List | admin | 2016.06.07 | 309 |
77 | DBMS_NETWORK_ACL_ADMIN | admin | 2016.06.07 | 348 |
76 | DBMS_NETWORK_ACL_ADMIN | admin | 2016.06.07 | 361 |
75 | APEX Web Services Proxy Settings | admin | 2016.06.07 | 372 |
74 | How to set a proxy in UTL_HTTP | admin | 2016.06.07 | 329 |
73 | function get area | admin | 2016.06.08 | 334 |
72 | Membership Management | admin | 2016.06.09 | 441 |
71 | control break | admin | 2016.06.25 | 407 |
70 | SQL | admin | 2016.07.15 | 404 |
69 | JavaScript for Member List | admin | 2016.08.17 | 441 |
68 | APEX Password Change | admin | 2016.08.26 | 467 |
67 | SQL Basics - Lesson 1 - Introduction | admin | 2017.06.17 | 101 |