Oracle 11g Release 2

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

CREATE TABLE tbl ( start_date, end_date ) as
 select date'2019-06-04', date'2019-06-06' from dual union all
 select date'2019-06-11', date'2019-06-13' from dual;
2 rows affected

with dates (dte, edte) as (
      select A.START_DATE, A.END_DATE
      FROM tbl A
      WHERE A.START_DATE <> A.END_DATE
      union all
      select dte + 1, edte
      from dates
      where dte < edte
     )
select dte
from dates;


DTE


04-JUN-19

11-JUN-19


WITH dates (dte, edte, step ) AS (
  SELECT A.START_DATE, A.END_DATE, 0
  FROM   tbl A
UNION ALL
  SELECT dte, edte, step + 1
  FROM   dates
  WHERE  dte + step + 1 <= edte
)
SELECT dte + step
FROM   dates;


DTE+STEP


04-JUN-19

11-JUN-19

05-JUN-19

12-JUN-19

06-JUN-19

13-JUN-19