Oracle 18c

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

alter session set nls_date_format='dd/mm/yyyy';
create table test(
  RecordId int,
  foo_id int,
  high_speed int,
  speed int,
  DateFrom date,
  DateTo date
);
insert all
  into test values(666542, 12, 60, 10, '09/11/2011', '10/11/2011')
  into test values(666986, 13, 20, 20, '11/11/2011', '11/11/2011')
  into test values(666996, 12, 0,  0,  '13/11/2011', '17/11/2011')
  into test values(755485, 12, 0,  0,  '01/11/2011', '14/11/2011')
  into test values(758545, 12, 70, 50, '15/11/2011', '26/11/2011')
  into test values(796956, 12, 40, 40, '09/11/2011', '09/11/2011')
  into test values(799656, 13, 25, 20, '09/11/2011', '09/11/2011')
  into test values(808845, 12, 0,  0,  '15/11/2011', '15/11/2011')
  into test values(823323, 12, 0,  0,  '15/11/2011', '16/11/2011')
  into test values(823669, 12, 0,  0,  '17/11/2011', '18/11/2011')
  into test values(899555, 12, 0,  0,  '18/11/2011', '19/11/2011')
  into test values(990990, 12, 20, 10, '12/11/2011', '12/11/2011')
select * from dual;
12 rows affected

SELECT
  foo_id, high_speed, speed,
  NVL(DateFromZ, DateFrom) DateFrom,
  NVL(DateToZ, DateTo) DateTo
FROM test
MATCH_RECOGNIZE (
  ORDER BY RecordId
  MEASURES
    FIRST(zeros.DateFrom) AS DateFromZ,
    FINAL LAST(zeros.DateTo) AS DateToZ,
    COUNT(*) AS cnt
  ALL ROWS PER MATCH WITH UNMATCHED ROWS
  PATTERN (zeros+)
  DEFINE
    zeros AS zeros.speed = 0
)
WHERE speed > 0 OR cnt = 1
ORDER BY RecordId;


FOO_ID
HIGH_SPEED
SPEED
DATEFROM
DATETO


12
60
10
09/11/2011
10/11/2011

13
20
20
11/11/2011
11/11/2011

12
0
0
13/11/2011
14/11/2011

12
70
50
15/11/2011
26/11/2011

12
40
40
09/11/2011
09/11/2011

13
25
20
09/11/2011
09/11/2011

12
0
0
15/11/2011
19/11/2011

12
20
10
12/11/2011
12/11/2011


-- all the same, but the scribble was added
WITH
  a AS (
    SELECT
      t.*,
      DECODE(speed, 0, SUM(DECODE(speed, 0, 0, 1))
                         OVER(ORDER BY RecordId), -1) AS g
    FROM test t
  ),
  b AS (
    SELECT a.*,
      FIRST_VALUE(DateFrom) OVER(PARTITION BY g ORDER BY RecordId) AS DateFromZ,
      LAST_VALUE(DateTo) OVER(PARTITION BY g
                              ORDER BY RecordId
                              ROWS BETWEEN UNBOUNDED PRECEDING AND
                                           UNBOUNDED FOLLOWING) AS DateToZ,
      ROW_NUMBER() OVER(PARTITION BY g ORDER BY RecordId) AS cnt
    FROM a
  )
SELECT
  foo_id, high_speed, speed,
  DECODE(speed, 0, DateFromZ, DateFrom) AS DateFrom,
  DECODE(speed, 0, DateToZ, DateTo) AS DateTo
FROM b
WHERE speed > 0 OR cnt = 1
ORDER BY RecordId;


FOO_ID
HIGH_SPEED
SPEED
DATEFROM
DATETO


12
60
10
09/11/2011
10/11/2011

13
20
20
11/11/2011
11/11/2011

12
0
0
13/11/2011
14/11/2011

12
70
50
15/11/2011
26/11/2011

12
40
40
09/11/2011
09/11/2011

13
25
20
09/11/2011
09/11/2011

12
0
0
15/11/2011
19/11/2011

12
20
10
12/11/2011
12/11/2011

FOO_ID	HIGH_SPEED	SPEED	DATEFROM	DATETO
12	60	10	09/11/2011	10/11/2011
13	20	20	11/11/2011	11/11/2011
12	0	0	13/11/2011	14/11/2011
12	70	50	15/11/2011	26/11/2011
12	40	40	09/11/2011	09/11/2011
13	25	20	09/11/2011	09/11/2011
12	0	0	15/11/2011	19/11/2011
12	20	10	12/11/2011	12/11/2011