Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE SERVICES (SRVC, START_DATE, END_DATE) AS
SELECT 'Therapy',  DATE '2020-01-01', DATE '2020-01-05' FROM DUAL UNION ALL
SELECT 'Baseball', DATE '2020-02-15', DATE '2020-02-18' FROM DUAL UNION ALL
SELECT 'Other',    DATE '2020-02-15', DATE '2020-02-18' FROM DUAL;
3 rows affected

SELECT *
  FROM SERVICES


SRVC
START_DATE
END_DATE


Therapy
01-JAN-20
05-JAN-20

Baseball
15-FEB-20
18-FEB-20

Other
15-FEB-20
18-FEB-20


SELECT DISTINCT SRVC, START_DATE + (LEVEL-1) AS SRVC_DATE
  FROM SERVICES
  CONNECT BY LEVEL <= (END_DATE - START_DATE)+1
  ORDER BY 1, 2


SRVC
SRVC_DATE


Baseball
15-FEB-20

Baseball
16-FEB-20

Baseball
17-FEB-20

Baseball
18-FEB-20

Other
15-FEB-20

Other
16-FEB-20

Other
17-FEB-20

Other
18-FEB-20

Therapy
01-JAN-20

Therapy
02-JAN-20

Therapy
03-JAN-20

Therapy
04-JAN-20

Therapy
05-JAN-20


SELECT SRVC, START_DATE + (LEVEL-1) AS SRVC_DATE
  FROM SERVICES
  CONNECT BY LEVEL <= (END_DATE - START_DATE)+1
  ORDER BY 1, 2


SRVC
SRVC_DATE


Baseball
15-FEB-20

Baseball
16-FEB-20

Baseball
16-FEB-20

Baseball
16-FEB-20

Baseball
17-FEB-20

Baseball
17-FEB-20

Baseball
17-FEB-20

Baseball
17-FEB-20

Baseball
17-FEB-20

Baseball
17-FEB-20

Baseball
17-FEB-20

Baseball
17-FEB-20

Baseball
17-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Baseball
18-FEB-20

Other
15-FEB-20

Other
16-FEB-20

Other
16-FEB-20

Other
16-FEB-20

Other
17-FEB-20

Other
17-FEB-20

Other
17-FEB-20

Other
17-FEB-20

Other
17-FEB-20

Other
17-FEB-20

Other
17-FEB-20

Other
17-FEB-20

Other
17-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Other
18-FEB-20

Therapy
01-JAN-20

Therapy
02-JAN-20

Therapy
02-JAN-20

Therapy
02-JAN-20

Therapy
03-JAN-20

Therapy
03-JAN-20

Therapy
03-JAN-20

Therapy
03-JAN-20

Therapy
03-JAN-20

Therapy
03-JAN-20

Therapy
03-JAN-20

Therapy
03-JAN-20

Therapy
03-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
04-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20

Therapy
05-JAN-20
SRVC	START_DATE	END_DATE
Therapy	01-JAN-20	05-JAN-20
Baseball	15-FEB-20	18-FEB-20
Other	15-FEB-20	18-FEB-20