title: SQL Sum Using logic to choose Plus or Minus (Oracle)
body: <p>Not sure if this is possible or not in straight SQL.</p>
  
  <p>Is it possible to choose the operator for a sum using the likes of a CASE Statement or similar logic.</p>
  
  <p>e.g.</p>
  
  <pre><code>select 
    (select 1 from dual) 
    (case when (select 1 from dual) = 1 then + else - end) 
    (select 2 from dual)
  from dual
  </code></pre>
  
  <p>Thanks in return.</p>