Oracle-SQL : Select daily basis of count(item) between two dates
<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>