Oracle 11g Release 2

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

create table mytable(start_date date, end_date date);


insert into mytable values (to_date('01/31/2020','mm/dd/yyyy'),to_date('02/03/2020','mm/dd/yyyy'));
1 rows affected

select
   t.start_date + rownum -1 as dt,
   t.start_date,
   t.end_date
from
   all_objects, mytable t
where
   rownum <=
   t.end_date- t.start_date+1;


DT
START_DATE
END_DATE


31-JAN-20
31-JAN-20
03-FEB-20

01-FEB-20
31-JAN-20
03-FEB-20

02-FEB-20
31-JAN-20
03-FEB-20

03-FEB-20
31-JAN-20
03-FEB-20

DT	START_DATE	END_DATE
31-JAN-20	31-JAN-20	03-FEB-20
01-FEB-20	31-JAN-20	03-FEB-20
02-FEB-20	31-JAN-20	03-FEB-20
03-FEB-20	31-JAN-20	03-FEB-20