Loading ...
Sorry, an error occurred while loading the content.

How to generate fibonacci series in Oracle.

Expand Messages
  • m arju
    How to generate fibonacci series in Oracle. Way 1: with data as (select level levels from dual connect by level
    Message 1 of 1 , Oct 18, 2008
    • 0 Attachment
      How to generate fibonacci series in Oracle.
      Way 1:


      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[1] = 0 , f[2] = 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

      http://arjudba.blogspot.com


      Send instant messages to your online friends http://uk.messenger.yahoo.com

      [Non-text portions of this message have been removed]
    Your message has been successfully submitted and would be delivered to recipients shortly.