Write a PL/ SQL program to generate Fibonacci series - Computer Programming

Latest

C C++ Java Python Perl Programs Examples with Output -useful for Schools & College Students

Wednesday, October 12, 2011

Write a PL/ SQL program to generate Fibonacci series


Write a PL/ SQL program to generate Fibonacci series
declare
a number;
b number;
c number;
n number;
i number;
begin
n:=&n;
a:=0;
b:=1;
dbms_output.put_line(a);
dbms_output.put_line(b);
for i in 1..n-2
loop
c:=a+b;
dbms_output.put_line(c);
a:=b;
b:=c;
end loop;
end;
/
OUTPUT:
SQL> @ FIBONACCI.sql
Enter value for n: 3
old   8: n:=&n;
new   8: n:=3;
0
1
1
PL/SQL procedure successfully completed.

No comments:

Post a Comment