PL/SQL block to obtain Fibonacci series

Q. Write a PL/SQL block to obtain Fibonacci series.

Answer:

Fibonacci series: It is a series of a numbers, in which each number is the sum of two previous numbers.

For example:
1, 1, 2, 3, 5, 8, 13, 21.........etc.

The following code will calculate the Fibonacci series of a given number.

declare
   a number(3):=1;
   b number(3):=1;
   c number(3);
   n number(3):=&n;
begin
  Dbms_output.put_line('the fibinocci series is:');
  while a<=n
    loop
        dbms_output.put_line(a);
        c:=a+b;
        a:=b;
        b:=c;
     end loop;
  end;
/


Output:

fibonacci series
▲