title: How to convert full outer join query to O-R query?
body: <p>I'm converting relational database into object-relational in Oracle.</p>
  
  <p>I have a query that uses full outer join in the old one.</p>
  
  <p>Is it possible to write the same query for O-R database without explicitly using full outer join?</p>
  
  <p>For normal inner join it simple, I just use dot notation together with ref/deref.</p>
  
  <p>I'm interested in this in general so let's say the relational query is:</p>
  
  <pre><code>select a.attr, b.attr from a full outer join b on (a.fk = b.pk);
  </code></pre>
  
  <p>I want to know if it's a good idea to do it this way:</p>
  
  <pre><code>select a.attr, b.attr from a_obj a full outer join b_obj b on (a.b_ref = ref(b));
  </code></pre>