today:
28
yesterday:
167
Total:
993,532

SQL FOR LOOP

admin 2016.05.20 13:42 Views : 259

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 TEST admin 2023.04.28 33
105 WHDR email address admin 2023.04.13 48
104 TEST admin 2023.03.27 88
103 GP 영수증 (3) -01/04/2023 admin 2023.01.04 46
102 GP - 영수증 (2) admin 2022.11.07 61
101 GP 영수증 본문 admin 2022.11.07 58
100 STARTUP admin 2022.09.01 73
99 SQL Developer Password change / EXPORT & IMPORT admin 2022.03.18 141
98 Forgot Oracle username and password, how to retrieve? admin 2022.03.18 137
97 SQL DEVELOPER file admin 2022.03.17 98
96 How to Install Oracle 11g on Windows 10 - 64 bit | Download / Install Oracle 11g Database file admin 2022.03.17 110
95 QRCODE admin 2020.05.25 397
94 JK admin 2019.02.05 684
93 ACTION admin 2019.01.11 6438
92 SELECT last_name FROM admin 2018.12.12 727
91 IMP admin 2018.10.08 695
90 CREATE TABLE admin 2018.09.25 462
89 Change Admin PASSWORD admin 2018.07.31 219
88 VERY IMPORTANT admin 2018.06.26 214
87 IF/ELSE ... CASE WHEN admin 2018.06.25 201