title: How to use oracle outer join with a filter where clause
body: <p>If i write a sql:</p>
  
  <pre><code>select * 
  from a,b 
  where     a.id=b.id(+) 
        and b.val="test"
  </code></pre>
  
  <p>and i want all records from a where  corresponding record in b does not exist or it exists with val="test", is this the correct query?</p>