title: Oracle Sql NOT NULL xor NULL?
body: <p>I'm selecting a group of records and I want to filter a column in the logic of XOR - IS NOT NULL xor IS NULL.</p>
  
  <pre><code>--basic
  SELECT make, model
  FROM cars
  
  results
  --------
  ford   taurus
  ford   (null)
  toyota camry
  toyota (null)
  honda  (null)
  
  --Obviously XOR is not a real Oracle operator
  --This is what I'm trying to do..
  SELECT make, model
  FROM cars
  WHERE model IS NOT NULL
    XOR model IS NULL 
  
  results (pulls records where model IS NOT NULL, falling back to NULL if necessary)
  --------
  ford   taurus
  toyota camry
  honda  (null)
  </code></pre>
  
  <p>Can anyone give me insight on how to achieve the desired result I'm looking for?  I'm struggling on this one!</p>
  
  <p>Many thanks!</p>