title: How to combine 2 select statements in oracle
body: <p>i have table test2.it contains </p>
  
  <h2>       ID</h2>
  
  <pre><code>    1
      4
      5
     10 
  </code></pre>
  
  <p>now i found missing numbers in this sequence.with this query</p>
  
  <pre><code>SELECT min_ID - 1 + level mn FROM 
  ( SELECT MIN(ID) min_ID , MAX(ID) max_ID FROM test2 ) 
  CONNECT BY level &lt;= max_ID - min_ID + 1 minus SELECT ID FROM test2
  </code></pre>
  
  <p>output is:</p>
  
  <pre><code>MN
  ---   
  2   
  3   
  6   
  7   
  8   
  9
  </code></pre>
  
  <p>now i want to combine these 2 columns.I am unable to do this please help me.
  i want output like</p>
  
  <pre><code>  1        2
    4        3
    7        5
    10       6
             8
             9
  </code></pre>