Oracle 21c

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

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE table_name (ID, "DATE", OE) AS
SELECT 11, DATE '2021-03-06', 2926 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-07', 3879 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-08', 3879 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-09', 3879 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-10', 2926 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-11', 2926 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-12', 2926 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-13', 2926 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-14', 2926 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-15', 2926 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-16', 1344 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-17', 1344 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-18', 1344 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-19', 1344 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-20', 1344 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-21', 1344 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-22', 2926 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-23', 2926 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-24', 2926 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-25', 2926 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-26', 2926 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-27', 2926 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-28', 2926 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-29', 2926 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-30', 2926 FROM DUAL UNION ALL
SELECT 11, DATE '2021-03-31', 2926 FROM DUAL UNION ALL
SELECT 11, DATE '2021-04-01', 1549 FROM DUAL UNION ALL
SELECT 11, DATE '2021-04-02', 1549 FROM DUAL UNION ALL
SELECT 11, DATE '2021-04-03', 1549 FROM DUAL UNION ALL
SELECT 11, DATE '2021-04-04', 2926 FROM DUAL;
30 rows affected

SELECT *
FROM   table_name
MATCH_RECOGNIZE(
  PARTITION BY id
  ORDER     BY "DATE"
  MEASURES
    FIRST(oe)     AS oe,
    FIRST("DATE") AS mind,
    LAST("DATE")  AS maxd
  PATTERN (same_oe+)
  DEFINE
    same_oe AS oe = FIRST(oe)
)


ID
OE
MIND
MAXD


11
2926
2021-03-06 00:00:00
2021-03-06 00:00:00

11
3879
2021-03-07 00:00:00
2021-03-09 00:00:00

11
2926
2021-03-10 00:00:00
2021-03-15 00:00:00

11
1344
2021-03-16 00:00:00
2021-03-21 00:00:00

11
2926
2021-03-22 00:00:00
2021-03-31 00:00:00

11
1549
2021-04-01 00:00:00
2021-04-03 00:00:00

11
2926
2021-04-04 00:00:00
2021-04-04 00:00:00

ID	OE	MIND	MAXD
11	2926	2021-03-06 00:00:00	2021-03-06 00:00:00
11	3879	2021-03-07 00:00:00	2021-03-09 00:00:00
11	2926	2021-03-10 00:00:00	2021-03-15 00:00:00
11	1344	2021-03-16 00:00:00	2021-03-21 00:00:00
11	2926	2021-03-22 00:00:00	2021-03-31 00:00:00
11	1549	2021-04-01 00:00:00	2021-04-03 00:00:00
11	2926	2021-04-04 00:00:00	2021-04-04 00:00:00