with n (u) as ( select 1 from dual union all select n.u+1 from n where n.u < 8 ), q as ( select n.u v, m.u w from n, n m ), r (v,w,s,d,e) as ( select v,w, v,w,sum(w)over(order by w) from q where v = 1 union all select q.v,q.w ,r.d ,r.e ,sum(r.e)over(order by r.w) from r inner join q on r.w=q.w and r.v+1=q.v ) select v,w,s from r ;
2019-10-02
Pascal Matrix - Wishes Come True
Years ago I made a wish in my blog that an analytic function should work in a recursive query. My approach to generate Pascal Matrix seems to work with Oracle 19c database.
Subscribe to:
Post Comments (Atom)
About Me
- Rafu
- I am Timo Raitalaakso. I have been working since 2001 at Solita Oy as a Senior Database Specialist. My main focus is on projects involving Oracle database. Oracle ACE alumni 2012-2018. In this Rafu on db blog I write some interesting issues that evolves from my interaction with databases. Mainly Oracle.
No comments:
Post a Comment