today:
626
yesterday:
793
Total:
1,014,829

SQL FOR LOOP

admin 2016.05.20 13:42 Views : 278

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
106 DBMS_NETWORK_ACL_ADMIN admin 2016.06.07 361
105 ADD_PRIVILEGE (2nd STEP) admin 2016.06.07 360
104 Access Control List (ACL) admin 2016.06.07 350
103 DBMS_NETWORK_ACL_ADMIN admin 2016.06.07 348
102 function get area admin 2016.06.08 334
101 How to set a proxy in UTL_HTTP admin 2016.06.07 329
100 CREATE_ACL (1st STEP) admin 2016.06.07 320
99 ACL 보기 admin 2016.06.07 319
98 Assign a network host to Access Control List admin 2016.06.07 309
97 Oracle 11g Access Control List for External Network Services admin 2016.06.07 306
96 CAPTCHA PLUG-IN admin 2016.05.27 304
95 영수증 2023 file admin 2024.01.04 285
94 SUBSTR admin 2016.05.26 280
» FOR LOOP admin 2016.05.20 278
92 Validation to detect text in numeric field admin 2018.05.19 254
91 ROWNUM admin 2016.05.19 246
90 Change Admin PASSWORD admin 2018.07.31 243
89 Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 ) admin 2016.05.06 242
88 VERY IMPORTANT admin 2018.06.26 239
87 How-To Document / Change a Logo in a Page Template admin 2016.04.16 239