Oracle 11g Release 2

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

CREATE TABLE heats (
  start_date DATE,
  stop_date DATE,
  sample_date DATE,
  sample_value integer
)
INSERT ALL
INTO heats (start_date, stop_date,sample_date,sample_value) VALUES (TO_DATE('11/11/2019 8:00:00 AM', 'MM:DD:YYYY HH:MI:SS AM'),TO_DATE('11/14/2019 9:00:00 AM', 'MM:DD:YYYY HH:MI:SS AM'),TO_DATE('11/11/2019 8:10:00 AM' , 'MM:DD:YYYY HH:MI:SS AM'),10)
INTO heats (start_date, stop_date,sample_date,sample_value) VALUES (TO_DATE('11/11/2019 8:00:00 AM', 'MM:DD:YYYY HH:MI:SS AM'),TO_DATE('11/14/2019 9:00:00 AM', 'MM:DD:YYYY HH:MI:SS AM'),TO_DATE('11/14/2019 8:14:00 AM' , 'MM:DD:YYYY HH:MI:SS AM'),20)
INTO heats (start_date, stop_date,sample_date,sample_value) VALUES (TO_DATE('11/11/2019 8:00:00 AM', 'MM:DD:YYYY HH:MI:SS AM'),TO_DATE('11/14/2019 9:00:00 AM', 'MM:DD:YYYY HH:MI:SS AM'),TO_DATE('11/14/2019 8:20:00 AM', 'MM:DD:YYYY HH:MI:SS AM'),15)
INTO heats (start_date, stop_date,sample_date,sample_value) VALUES (TO_DATE('11/11/2019 8:00:00 AM', 'MM:DD:YYYY HH:MI:SS AM'),TO_DATE('11/14/2019 9:00:00 AM', 'MM:DD:YYYY HH:MI:SS AM'),TO_DATE('11/14/2019 8:40:00 AM', 'MM:DD:YYYY HH:MI:SS AM'),10)
INTO heats (start_date, stop_date,sample_date,sample_value) VALUES (TO_DATE('11/11/2019 8:00:00 AM', 'MM:DD:YYYY HH:MI:SS AM'),TO_DATE('11/14/2019 9:00:00 AM', 'MM:DD:YYYY HH:MI:SS AM'),TO_DATE('11/14/2019 8:50:00 AM', 'MM:DD:YYYY HH:MI:SS AM'),21)
INTO heats (start_date, stop_date,sample_date,sample_value) VALUES (TO_DATE('11/11/2019 8:00:00 AM', 'MM:DD:YYYY HH:MI:SS AM'),TO_DATE('11/14/2019 9:00:00 AM', 'MM:DD:YYYY HH:MI:SS AM'),TO_DATE('11/14/2019 8:55:00 AM', 'MM:DD:YYYY HH:MI:SS AM'),20)
 
SELECT * FROM dual
6 rows affected

select * from heats


START_DATE
STOP_DATE
SAMPLE_DATE
SAMPLE_VALUE


11-NOV-19
14-NOV-19
11-NOV-19
10

11-NOV-19
14-NOV-19
14-NOV-19
20

11-NOV-19
14-NOV-19
14-NOV-19
15

11-NOV-19
14-NOV-19
14-NOV-19
10

11-NOV-19
14-NOV-19
14-NOV-19
21

11-NOV-19
14-NOV-19
14-NOV-19
20

START_DATE	STOP_DATE	SAMPLE_DATE	SAMPLE_VALUE
11-NOV-19	14-NOV-19	11-NOV-19	10
11-NOV-19	14-NOV-19	14-NOV-19	20
11-NOV-19	14-NOV-19	14-NOV-19	15
11-NOV-19	14-NOV-19	14-NOV-19	10
11-NOV-19	14-NOV-19	14-NOV-19	21
11-NOV-19	14-NOV-19	14-NOV-19	20