我有一些SQL Server代码要迁移到Oracle 11g。有很多这样的递归OUTER APPLY语句:
select a.colA
,bb.retB
,cc.retC
from tableA a
outer apply
(
select funcB(b.colB) as retB
from tableB b
where b.colA = a.colA
) bb
outer apply
(
select funcC(bb.retB, c.colC) as retC
from tableC c
where c.colB = bb.retB
) cc
.
关键点