title: Oracle equivalent recursive OUTER APPLY in SQL Server
body: <p>I have some SQL Server code to migrate to Oracle 11g. There are a lot of recursive <code>OUTER APPLY</code> statements like this one:</p>
  
  <pre><code>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
  </code></pre>
  
  <p>......</p>
  
  <p>The key point is that OUTER APPLY block bb depends on the result of a, and <code>OUTER APPLY</code> block cc depends on the result of <code>OUTER APPLY</code> block bb, and so on. How can I rewrite these structures in Oracle database and keep them as readable as in SQL Server? Thanks!</p>