Days between two parameter dates

 SELECT :pSDATE + LEVEL - 1     dt

                   FROM DUAL

             CONNECT BY LEVEL <= ( :pEDATE - :pSDATE + 1);