Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

with fibo(s2,s1,n) as(
    select 1  ,1  ,1  from dual
    union all
    select s1+s2,s2,n+1 from fibo where n<12
)
select s2 from fibo;


S2


1

2

3

5

8

13

21

34

55

89

144

233


with fibo(s,n) as(
    select 1,1 from dual
    union all
    select LAG(s, 1, 0) OVER ( ORDER BY s) +LAG(s, 2, 0) OVER ( ORDER BY s),n+1 from fibo where n<12
)
Select * from fibo


S
N


1
1

0
2

0
3

0
4

0
5

0
6

0
7

0
8

0
9

0
10

0
11

0
12


with fibo(s,n) as(
    select 1,12 from dual
    union all
    select
        Lead(s, 1, 0) OVER (  ORDER BY s) +s,
        n-1
    from fibo where n>0
)
select * from fibo


S
N


1
12

1
11

1
10

1
9

1
8

1
7

1
6

1
5

1
4

1
3

1
2

1
1

1
0


with fibo(s,d1,d2,n) as(
    select 1,0,0,1 from dual
    union all
    select
        2*s,LAG(s, 1, 0) OVER (  ORDER BY s) ,
        LAG(s, 2, 0) OVER ( ORDER BY s),n+1
    from fibo where n<12
)
select * from fibo


S
D1
D2
N


1
0
0
1

2
0
0
2

4
0
0
3

8
0
0
4

16
0
0
5

32
0
0
6

64
0
0
7

128
0
0
8

256
0
0
9

512
0
0
10

1024
0
0
11

2048
0
0
12

S	D1	D2	N
1	0	0	1
2	0	0	2
4	0	0	3
8	0	0	4
16	0	0	5
32	0	0	6
64	0	0	7
128	0	0	8
256	0	0	9
512	0	0	10
1024	0	0	11
2048	0	0	12