pa DB2 i oracle imaju rekurziju unutar samog select poziva bez ugnjezdjenih procedura. Primer DB2 select-a
Code:
with
D(DEO,sadrzi,kol) AS(
VALUES(1,2,7),(1,5,13),(1,4,25),(2,5,14),(2,6,18),(3,6,26),(4,7,21),(6,8,7)
),
potomak(sadrzi,kol) as (
select sadrzi,kol from d where deo=1
union all
select d.sadrzi,d.kol*p.kol from potomak p,d
where p.sadrzi=d.deo
)
select sadrzi,sum(kol) as kol
from potomak
group by sadrzi;