title: Generating dates between two dates
body: <p>I need to generate all dates between two given dates. This works fine as long as there is just one date range. However, if I have multiple date ranges, this solution doesn't work. I have searched here as well as on asktom, but couldn't locate relevant pointers/solution.</p>
  
  <p>I tried both the solutions using all_objects and CONNECT BY ROWNUM, but no luck. Here is the problem statement: <a href="http://sqlfiddle.com/#!4/7837c/13">sqlfiddle</a></p>
  
  <p><strong>Input</strong></p>
  
  <pre><code>ID  START_DATE      END_DATE 
  101 April, 01 2013  April, 10 2013 
  102   May, 10 2013    May, 12 2013
  </code></pre>
  
  <p><strong>Output</strong></p>
  
  <pre><code>ID  Dates
  101 April, 01 2013 
  101 April, 02 2013  
  101 April, 03 2013  
  101 April, 04 2013  
  101 April, 05 2013  
  101 April, 06 2013  
  101 April, 07 2013  
  101 April, 08 2013  
  101 April, 09 2013  
  101 April, 10 2013  
  102   May, 10 2013  
  102   May, 11 2013  
  102   May, 12 2013
  </code></pre>