title: Oracle-SQL : Select daily basis of count(item) between two dates
body: <p>I need to spread a row with specified range of dates (<code>STARTDATE</code>, <code>ENDDATE</code>) into multiple rows with successive dates from the range. Please see the image below</p>
  
  <p><a href="https://i.stack.imgur.com/3B7w6.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3B7w6.jpg" alt="enter image description here"></a></p>
  
  <p>Here is example of the data</p>
  
  <pre><code>&gt; MODELCD  PRODUCTCD  PROCESSCD  LS_PROCESSCD  EST_STARTDATE  EST_ENDDATE
     P9218   22186844   15VV2111    DS            21/12/2015     10/1/2016
     P9218   22269836   15VV2121    MC            23/2/2016      21/3/2016
     P9218   22186844   15VV2111    MC            9/2/2016       7/3/2016
  </code></pre>
  
  <p>And the expected result shown as below </p>
  
  <pre><code> MODELCD  PRODUCTCD  PROCESSCD  LS_PROCESSCD  PROCESS_DATE  
   P9218    22186844   15VV2111   DS            21/12/2015     
   P9218    22186844   15VV2111   DS            22/12/2015
   P9218    22186844   15VV2111   DS            23/12/2015
     '         '         '        '               '
     '         '         '        '               '
     '         '         '        '               '
   P9218   22186844   15VV2111    DS            10/01/2016
   P9218   22269836   15VV2121    MC            23/2/2016      
   P9218   22269836   15VV2121    MC            24/2/2016
     '         '         '         '                '
     '         '         '         '                '
     '         '         '         '                '
   P9218   22269836   15VV2121    MC            21/3/2016
  </code></pre>