title: Result set in Oracle with Union
body: <p>I have made union with two query in Oracle SQL</p>
  <pre><code>SELECT account_number, SUM(amount_settled)    
    FROM table W
   WHERE account_number= &amp;acc
     AND Component = 'PROFIT_1'
   GROUP BY account_number
   UNION 
  SELECT account_number, SUM(amount)  
    FROM table S
   WHERE account_number=  &amp;acc
     AND amount_tag= 'PROFIT_2' 
   GROUP BY account_number 
   ORDER BY account_number 
  </code></pre>
  <p>I am  getting  value in result  set as one  below  the other</p>
  <pre><code>SUM(AMOUNT_SETTLED)
  1   36260.16
  2   36342.16
  </code></pre>
  <p>I want  to  display in single row on beside the other</p>
  <pre><code>SUM(AMOUNT_SETTLED)       SUM(E.AMOUNT)
  36260.16                  36342.16
  </code></pre>
  <p>how to achieve  this with two Different Table in Oracle</p>