today:
150
yesterday:
311
Total:
1,018,389

SQL FOR LOOP

admin 2016.05.20 13:42 Views : 293

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
126 ACTION admin 2019.01.11 6479
125 Fundamentals of PL/SQL admin 2016.05.10 2053
124 QR Code plugin admin 2017.11.30 1598
123 QR Code plugin Process admin 2017.11.30 968
122 How to Update Oracle XE Version admin 2018.02.23 946
121 GP PRINT admin 2018.05.31 934
120 INSTR admin 2016.05.19 814
119 SELECT last_name FROM admin 2018.12.12 768
118 IMP admin 2018.10.08 745
117 TREE admin 2016.05.18 741
116 JK admin 2019.02.05 717
115 CREATE TABLE admin 2018.09.25 491
114 APEX Password Change admin 2016.08.26 469
113 Membership Management admin 2016.06.09 454
112 JavaScript for Member List admin 2016.08.17 453
111 SQL admin 2016.07.15 416
110 QRCODE admin 2020.05.25 412
109 control break admin 2016.06.25 411
108 DATE Compare admin 2018.05.22 384
107 APEX Web Services Proxy Settings admin 2016.06.07 380