title: Union null in Oracle
body: <p>I'm trying to combine 2 querys in oracle, those lines have the same value expect one field.</p>
  
  <p>Ex:  </p>
  
  <pre><code>SELECT NAME, AGE, EMAIL, DATE FROM table_a WHERE NAME = 'JOAO' AND FLAG = '0'
  UNION
  SELECT NAME, AGE, EMAIL, DATE FROM table_a WHERE NAME = 'JOAO' AND FLAG = '1'
  </code></pre>
  
  <p>Result:</p>
  
  <pre><code>NAME   AGE   EMAIL      DATE   
  JOAO   23    a@a.com    20150414
  JOAO   23    a@a.com    null
  </code></pre>
  
  <p>How i can group this lines?? I'm looking for something who can give me something like this result:</p>
  
  <pre><code>NAME   AGE   EMAIL      DATE   
  JOAO   23    a@a.com    20150414
  </code></pre>
  
  <p>Thank you
  (sorry for my english..)</p>