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