【oracle】获得两个日期之间的所有日期

SELECT A.REMARK_NAME,
A.REMARK_START_DATE,
A.REMARK_END_DATE,
A.REMARK_START_DATE + B.DIS - 1 H
FROM B_REMARK_DETAIL A,
(SELECT ROWNUM DIS
FROM (SELECT MAX(REMARK_END_DATE - REMARK_START_DATE) + 1 GAP
FROM B_REMARK_DETAIL)
CONNECT BY ROWNUM <= GAP) B
WHERE A.REMARK_END_DATE >= A.REMARK_START_DATE + B.DIS - 1
ORDER BY H