Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table_name ( start_dt, end_dt, id ) AS
SELECT DATE '2013-04-05', DATE '2013-04-09', 1 FROM DUAL
1 rows affected

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
WITH ranges ( start_dt, end_dt, id ) AS (
  SELECT start_dt, end_dt, id
  FROM   table_name
UNION ALL
  SELECT start_dt + INTERVAL '1' DAY, end_dt, id
  FROM   ranges
  WHERE  start_dt + INTERVAL '1' DAY <= end_dt
)
SELECT start_dt,
       id
FROM   ranges;


START_DT
ID


2013-04-05 00:00:00
1

2013-04-06 00:00:00
1

2013-04-07 00:00:00
1

2013-04-08 00:00:00
1

2013-04-09 00:00:00
1

START_DT	ID
2013-04-05 00:00:00	1
2013-04-06 00:00:00	1
2013-04-07 00:00:00	1
2013-04-08 00:00:00	1
2013-04-09 00:00:00	1