Monday, February 23, 2009

Program to print sum of first n natural nos In SQL.

SQL> Declare

2 i number:=0;

3 n number;

4 sum1 number:=0;

5 Begin

6 n:=&n;

7 while i

8 loop

9 sum1:=sum1+i;

10 dbms_output.put_line(i);

11 i:=i+1;

12 end loop;

13 dbms_output.put_line('The sum is:'||sum1);

14 End;

15 /

Enter value for n: 10

old 6: n:=&n;

new 6: n:=10;

PL/SQL procedure successfully completed.