Home » SQL & PL/SQL » SQL & PL/SQL » increment by 2 in oracle for loop
|
|
|
Re: increment by 2 in oracle for loop [message #130754 is a reply to message #130728] |
Tue, 02 August 2005 05:12  |
JSI2001
Messages: 1016 Registered: March 2005 Location: Scotland
|
Senior Member |
|
|
One way is to use arithmetic
SQL> Begin
2 for i IN 1..10 loop
3 dbms_output.put_line('- iteration '||i||' value '||i*2);--increment by 2
4 dbms_output.put_line('- iteration '||i||' value '||i*3);--increment by 3
5 dbms_output.put_line('- iteration '||i||' value '||i*10);--increment by 10
6 dbms_output.put_line('__________________________________');
7 end loop;
8 end;
9 /
- iteration 1 value 2
- iteration 1 value 3
- iteration 1 value 10
__________________________________
- iteration 2 value 4
- iteration 2 value 6
- iteration 2 value 20
__________________________________
- iteration 3 value 6
- iteration 3 value 9
- iteration 3 value 30
__________________________________
- iteration 4 value 8
- iteration 4 value 12
- iteration 4 value 40
__________________________________
- iteration 5 value 10
- iteration 5 value 15
- iteration 5 value 50
__________________________________
- iteration 6 value 12
- iteration 6 value 18
- iteration 6 value 60
__________________________________
- iteration 7 value 14
- iteration 7 value 21
- iteration 7 value 70
__________________________________
- iteration 8 value 16
- iteration 8 value 24
- iteration 8 value 80
__________________________________
- iteration 9 value 18
- iteration 9 value 27
- iteration 9 value 90
__________________________________
- iteration 10 value 20
- iteration 10 value 30
- iteration 10 value 100
__________________________________
PL/SQL procedure successfully completed.
HTH
Jim
|
|
|
Goto Forum:
Current Time: Thu Jun 05 18:46:51 CDT 2025
|