Using For...Loop

[Deven Oza]

Hi,
how can I write programm Using a for loop, that will print the first n integers.


Thank you
Dev

[nunnasujatha]

Hi this is the code:let me know any issues reg this

declare
2 i pls_integer :=1;
3 begin
4 loop
5 dbms_output.put _line(i);
6 i :=i+1;
7 exit when i=&n;
8 end loop;
9 end;
10 /
Enter value for n: 7
old 7: exit when i=&n;
new 7: exit when i=7;
1
2
3
4
5
6

[i2eye]

Here is another way to do a loop:

DECLARE
max_count NUMBER := 20;

BEGIN

FOR i IN 1..max_count LOOP

dbms_output.put _line(i);

END LOOP;

END;

[birdready2fly]

Hi,
how can I write programm Using a for loop, that will print the first n integers.
Thank you
Dev

set serveroutput on
declare
n number := &n
begin
for i in 1..n
loop
dbms_output.put _line(n);
end loop;
end ;

[nunnasujatha]

This is with FOR loop
SQL> begin
2 for i in 1..&n
3 loop
4 dbms_output.put _line(i);
5 end loop;
6 end ;
7 /
Enter value for n: 2
old 2: for i in 1..&n
new 2: for i in 1..2
1
2

PL/SQL procedure successfully completed.