oracle实现fibonacci数列方法一：select replace(max(sys_connect_by_path(fib||
oracle实现fibonacci数列方法一：
select replace(max(sys_connect_by_path(fib||', ', '/')),'/','')||'...' fiblist   
  from (   
   select n, fib, row_number()   
     over (order by n) r   
     from (select n, round((power((1+sqrt(5))*0.5, n)-power((1-sqrt(5))*0.5, n))/sqrt(5)) fib   
             from (select level n  
                     from dual  
                  connect by level )   
start with r=1   
connect by prior r = r-1;  
/* 
fiblist 
-------------------------------------------------------------------------------- 
1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89, 144, 233, 377, 610, 987, ... 
*/
方法二：
declare  
       a number;  
       b number;  
       c number;  
    begin  
       a:=0;  
       b:=1;  
       c:=1;  
       for i in 1..20 loop  
         dbms_output.put_line('the '||i||' number is:'||c);  
         c:=a+b;  
         a:=b;  
         b:=c;  
       end loop;  
    end;  
/* 
the 1 number is:1 
the 2 number is:1 
the 3 number is:2 
the 4 number is:3 
the 5 number is:5 
the 6 number is:8 
the 7 number is:13 
the 8 number is:21 
the 9 number is:34 
the 10 number is:55 
the 11 number is:89 
the 12 number is:144 
the 13 number is:233 
the 14 number is:377 
the 15 number is:610 
the 16 number is:987 
the 17 number is:1597 
the 18 number is:2584 
the 19 number is:4181 
the 20 number is:6765 
*/ 
方法三：
select max(s) || ', ...' fibonacci_list  
  from  
(select s  
   from dual  
   model   
     return all rows  
     dimension by ( 0 d )   
     measures ( cast(' ' as varchar2(200)) s, 0 f)  
     rules iterate (16)  
     (  f[iteration_number] = decode(iteration_number, 0, 1, 1, 1, f[iteration_number-1] + f[iteration_number-2]),   
        s[iteration_number] = decode(iteration_number, 0, to_char(f[iteration_number]), s[iteration_number-1] || ', ' || to_char(f[iteration_number]))  
     )  
)  
/* 
fibonacci_list 
-------------------------------------------------------------------------------- 
1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89, 144, 233, 377, 610, 987, ... 
*/
，