title: Is there any alternative for OUTER APPLY in Oracle?
body: <p>In the following example, I pass <strong>tbA.ID</strong> to <strong>tbC</strong> query. In this case, I used OUTER APPLY operator of SqlServer.</p>
  
  <pre><code>SELECT 
    ...
  FROM (SELECT ID FROM TableA ...) tbA
  OUTER APPLY (SELECT ... FROM TableB tbB WHERE tbA.ID = tbB.ID) tbC
  ...
  </code></pre>
  
  <p>In Oracle, we don't have the OUTER APPLY operator. So, how can I pass a value (tbA.ID) from the left side query to the right side query (tbC) of the join without modifying the structure of my query?</p>
  
  <p>Is there any alternative for OUTER APPLY in Oracle?</p>