title: Generate subsequent numbers between number range with SQL
body: <p>I have a table containing the following:</p>
  
  <pre><code>ID    low_value     high_value
  1     3270200000    3270210000
  2     3270210000    3270220000
  3     3270220000    3270230000
  4     3270230000    3270231000
  5     3270231000    3270232000
  6     3270232000    3270240000
  ...
  </code></pre>
  
  <p>In one single query using Oracle 11g I'd like to retrieve following result in which I list each unique number that exists within the range defined with</p>
  
  <pre><code>start value = with low_value /
  end value = high_value - 1
  </code></pre>
  
  <p>&nbsp;</p>
  
  <pre><code>low_value   high_value    unique_value
  3270200000  3270210000    3270200000    
  3270200000  3270210000    3270200001
  3270200000  3270210000    3270200002
  3270200000  3270210000    3270200003
  ...
  3270200000  3270210000    3270209999
  3270210000  3270220000    3270210001
  3270210000  3270220000    3270210002
  3270210000  3270220000    3270210002
  ...
  3270210000  3270220000    3270219999
  ...
  </code></pre>
  
  <p>I've been playing with the connect by &amp; model clause but so far without success.</p>
  
  <p>tx for your help</p>