How to generate fibonacci series in Oracle.
- How to generate fibonacci series in Oracle.
with data as (select level levels from dual
connect by level <= &how_may_rows)
select f from data
model dimension by (levels)
measures ( 0 f)
rules ( f = 0 , f = 1 , f[levels>2]=f[cv(levels)-2]+f[cv(levels)-1]
Enter value for how_may_rows: 10
Details in http://arjudba.blogspot.com/2008/10/how-to-generate-fibonacci-series-in.html
Send instant messages to your online friends http://uk.messenger.yahoo.com
[Non-text portions of this message have been removed]