Program for Fibonacci numbers in PL/SQL

The Fibonacci numbers are the numbers in the following integer sequence. 0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89, 144, …….. In mathematical terms, the sequence F_n of Fibonacci numbers is defined by the recurrence relation

F_n = F_n-1 + F_n-1

with seed values F₀= 0 and F₁ = 1. Given a number n, print n-th Fibonacci Number.

Input  : n = 2
Output : 1

Input  : n = 9
Output : 34

Below is the required implementation:

SQL

declare

-- declare variable first = 0,
-- second = 1 and temp of datatype number
first number := 0;
second number := 1;
temp number;

n number := 5;
i number;

begin

    dbms_output.put_line('Series:');

--print first two term first and second
    dbms_output.put_line(first);
    dbms_output.put_line(second);

-- loop i = 2 to n
    for i in 2..n
    loop
        temp:=first+second;

first := second;
second := temp;

--print terms of fibonacci series
    dbms_output.put_line(temp);
end loop;

end;
--Program End

Output:

0 1 1 2 3 5

Program for Fibonacci numbers in PL/SQL

Explore