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, code, sinfo, tdate) AS
SELECT 1, 'X', 'Y', DATE '2007-01-01' FROM DUAL UNION ALL
SELECT 1, 'X', 'Y', DATE '2007-04-06' FROM DUAL UNION ALL
SELECT 1, 'X', 'Y', DATE '2007-04-09' FROM DUAL;
3 rows affected

SELECT *
FROM   table_name
       MATCH_RECOGNIZE(
         PARTITION BY id, code, sinfo
         ORDER BY tdate
         MEASURES
           FIRST(tdate) AS tdate,
           LAST(tdate) AS tenddate
         PATTERN (first_row within_3_days*)
         DEFINE
           within_3_days AS tdate <= PREV(tdate) + INTERVAL '3' DAY
       )


ID
CODE
SINFO
TDATE
TENDDATE


1
X
Y
2007-01-01 00:00:00
2007-01-01 00:00:00

1
X
Y
2007-04-06 00:00:00
2007-04-09 00:00:00


SELECT id,
       code,
       sinfo,
       MIN(tdate) AS tdate,
       MAX(tdate) AS tenddate
FROM   table_name
GROUP BY id, code, sinfo, TRUNC(tdate, 'MM')


ID
CODE
SINFO
TDATE
TENDDATE


1
X
Y
2007-01-01 00:00:00
2007-01-01 00:00:00

1
X
Y
2007-04-06 00:00:00
2007-04-09 00:00:00

ID	CODE	SINFO	TDATE	TENDDATE
1	X	Y	2007-01-01 00:00:00	2007-01-01 00:00:00
1	X	Y	2007-04-06 00:00:00	2007-04-09 00:00:00