Let's Take Assumptions for the Start Date and End Date.
START DATE: SYSDATE-5
END DATE: SYSDATE
Syntax:
select (SYSDATE-5) + level - 1 dt
from dual
connect by level <= (
(SYSDATE) - (SYSDATE-5) + 1
);
Example:
select date'2021-06-08' + level - 1 dt
from dual
connect by level <= (
date'2021-06-14' - date'2021-06-08' + 1
);