Oracle 11g Release 2

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

CREATE TABLE t
    ("ID" int, "START_DATE" DATE, "END_DATE" DATE)
;

INSERT ALL 
    INTO t ("ID", "START_DATE", "END_DATE")
         VALUES (1, '01-Nov-2018', '01-Nov-2018')
    INTO t ("ID", "START_DATE", "END_DATE")
         VALUES (2, '04-Nov-2018', '07-Nov-2018')
    INTO t ("ID", "START_DATE", "END_DATE")
         VALUES (3, '09-Nov-2018', '09-Nov-2018')
    INTO t ("ID", "START_DATE", "END_DATE")
         VALUES (4, '11-Nov-2018', '12-Nov-2018')
SELECT * FROM dual
;
4 rows affected

select ID, START_DATE + LEVEL -1 FROM t CONNECT BY 
LEVEL <= ( END_DATE - START_DATE + 1 )
AND PRIOR ID = ID
AND PRIOR SYS_GUID() IS NOT NULL;


ID
START_DATE+LEVEL-1


1
01-NOV-18

2
04-NOV-18

2
05-NOV-18

2
06-NOV-18

2
07-NOV-18

3
09-NOV-18

4
11-NOV-18

4
12-NOV-18

ID	START_DATE+LEVEL-1
1	01-NOV-18
2	04-NOV-18
2	05-NOV-18
2	06-NOV-18
2	07-NOV-18
3	09-NOV-18
4	11-NOV-18
4	12-NOV-18