Write sql query to generate Fibonacci sequence in Oracle sql?
No, Oracle sql query doesn''t support single query to get the fabinocci sequence .
Becuase Oracle SQL is basically for data manipulationa and querying and it is not fr generating sequence or peforming iterative calculaiation like Fibonacci sequence.
The Fibonacci sequence define as which each number is the sum of the two preceding ones.
we call it Fibonacci numers those are part of series.
Example
0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55
we would need a PL/SQL code to achieve fibonacci sequence.
Below is the example.
PLSQL Code
DECLARE
n1 NUMBER := 0;
n2 NUMBER := 1;
n3 NUMBER;
BEGIN
DBMS_OUTPUT.PUT_LINE(n1);
DBMS_OUTPUT.PUT_LINE(n2);
FOR i IN 2..10 LOOP
n3 := n1 + n2;
n1 := n2;
n2 := n3;
DBMS_OUTPUT.PUT_LINE(n3);
END LOOP;
END;
This program uses a loop to calculate and print the Fibonacci sequence up to 100. The initial values of `n1` and `n2` are set to 0 and 1, respectively. The loop then calculates the next Fibonacci number (`n3`) by adding `n1` and `n2`, and updates the values of `n1` and `n2`. Finally, the program outputs the Fibonacci numbers using the `DBMS_OUTPUT.PUT_LINE` function.
0 Comments
Thanks for your message.