Oracle 18c

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

CREATE TABLE table_name ( CAT, NR, "DATE", VERSION, SOME_CODE ) AS
SELECT 'ABC', 	123, 	TIMESTAMP '2009-02-19 00:00:00 UTC', 	1, 	'OPP' FROM DUAL UNION ALL
SELECT 'ABC', 	456, 	TIMESTAMP '2009-03-18 00:00:00 UTC', 	1, 	'ZUM' FROM DUAL UNION ALL
SELECT 'ABC', 	444, 	TIMESTAMP '2009-03-18 00:00:00 UTC', 	1, 	'ZUM' FROM DUAL UNION ALL
SELECT 'ABC', 	444, 	TIMESTAMP '2009-03-18 00:00:00 UTC', 	2, 	'MUZ' FROM DUAL UNION ALL
SELECT 'ABC', 	456, 	TIMESTAMP '2009-04-18 00:00:00 UTC', 	2, 	'XXX' FROM DUAL UNION ALL
SELECT 'ABC', 	456, 	TIMESTAMP '2009-04-18 00:00:00 UTC', 	3, 	'XXX' FROM DUAL UNION ALL
SELECT 'ABC', 	456, 	TIMESTAMP '2009-04-18 00:00:00 UTC', 	4, 	'UIO' FROM DUAL UNION ALL
SELECT 'ABC', 	456, 	TIMESTAMP '2009-05-18 00:00:00 UTC', 	5, 	'RQA' FROM DUAL UNION ALL
SELECT 'DEF', 	637, 	TIMESTAMP '2018-02-16 00:00:00 UTC', 	1, 	'FAW' FROM DUAL UNION ALL
SELECT 'DEF', 	789, 	TIMESTAMP '2018-02-17 00:00:00 UTC', 	1, 	'WER' FROM DUAL UNION ALL
SELECT 'GHI', 	248, 	TIMESTAMP '2018-02-17 00:00:00 UTC', 	1, 	'QWE' FROM DUAL UNION ALL
SELECT 'GHI', 	248, 	TIMESTAMP '2019-02-17 00:00:00 UTC', 	2, 	'PPP' FROM DUAL UNION ALL
SELECT 'GHI', 	357, 	TIMESTAMP '2020-02-16 00:00:00 UTC', 	1, 	'FFF' FROM DUAL UNION ALL
SELECT 'GHI', 	420, 	TIMESTAMP '2020-02-16 00:00:00 UTC', 	1, 	'QDS' FROM DUAL UNION ALL
SELECT 'GHI', 	357, 	TIMESTAMP '2020-02-16 00:00:00 UTC', 	2, 	'GGG' FROM DUAL UNION ALL
SELECT 'GHI', 	357, 	TIMESTAMP '2020-02-16 00:00:00 UTC', 	3, 	'LLL' FROM DUAL UNION ALL
SELECT 'GHI', 	357, 	TIMESTAMP '2020-02-16 00:00:00 UTC', 	4, 	'LLL' FROM DUAL UNION ALL
SELECT 'GHI', 	357, 	TIMESTAMP '2020-08-16 00:00:00 UTC', 	4, 	'FFF' FROM DUAL UNION ALL
SELECT 'GHI', 	357, 	TIMESTAMP '2020-10-16 00:00:00 UTC', 	5, 	'ZZZ' FROM DUAL
19 rows affected

SELECT *
FROM   (
  SELECT t.*,
         TRUNC( "DATE", 'MM' ) AS month
  FROM   table_name t
)
MATCH_RECOGNIZE(
  PARTITION BY cat, month
  ORDER BY "DATE", version
  MEASURES
    MATCH_NUMBER()     AS mn,
    FIRST( some_code ) AS change_from,
    LAST( some_code )  AS change_to
  ONE ROW PER MATCH
  AFTER MATCH SKIP TO LAST change_code
  PATTERN ( strt change_code )
  DEFINE
    change_code AS change_code.some_code <> strt.some_code
)


CAT
MONTH
MN
CHANGE_FROM
CHANGE_TO


ABC
01-MAR-09
1
ZUM
MUZ

ABC
01-APR-09
1
XXX
UIO

DEF
01-FEB-18
1
FAW
WER

GHI
01-FEB-20
1
FFF
QDS

GHI
01-FEB-20
2
QDS
GGG

GHI
01-FEB-20
3
GGG
LLL


SELECT cat,
       month,
       COUNT(*)
FROM   (
  SELECT t.*,
         TRUNC( "DATE", 'MM' ) AS month
  FROM   table_name t
)
MATCH_RECOGNIZE(
  PARTITION BY cat, month
  ORDER BY "DATE", version
  ONE ROW PER MATCH
  AFTER MATCH SKIP TO LAST change_code
  PATTERN ( strt change_code )
  DEFINE
    change_code AS change_code.some_code <> strt.some_code
)
GROUP BY cat, month


CAT
MONTH
COUNT(*)


ABC
01-MAR-09
1

ABC
01-APR-09
1

DEF
01-FEB-18
1

GHI
01-FEB-20
3


SELECT *
FROM   table_name
MATCH_RECOGNIZE(
  PARTITION BY cat
  ORDER BY "DATE", version
  MEASURES
    MATCH_NUMBER()     AS mn,
    FIRST( "DATE" )    AS from_date,
    LAST( "DATE" )     AS to_date,
    FIRST( some_code ) AS change_from,
    LAST( some_code )  AS change_to
  ONE ROW PER MATCH
  AFTER MATCH SKIP TO LAST change_code
  PATTERN ( strt change_code )
  DEFINE
    change_code AS (
      change_code.some_code <> strt.some_code
      AND MONTHS_BETWEEN( change_code."DATE", strt."DATE" ) <= 1
    )
)


CAT
MN
FROM_DATE
TO_DATE
CHANGE_FROM
CHANGE_TO


ABC
1
19-FEB-09 00.00.00.000000000 UTC
18-MAR-09 00.00.00.000000000 UTC
OPP
ZUM

ABC
2
18-MAR-09 00.00.00.000000000 UTC
18-MAR-09 00.00.00.000000000 UTC
ZUM
MUZ

ABC
3
18-MAR-09 00.00.00.000000000 UTC
18-APR-09 00.00.00.000000000 UTC
MUZ
XXX

ABC
4
18-APR-09 00.00.00.000000000 UTC
18-APR-09 00.00.00.000000000 UTC
XXX
UIO

ABC
5
18-APR-09 00.00.00.000000000 UTC
18-MAY-09 00.00.00.000000000 UTC
UIO
RQA

DEF
1
16-FEB-18 00.00.00.000000000 UTC
17-FEB-18 00.00.00.000000000 UTC
FAW
WER

GHI
1
16-FEB-20 00.00.00.000000000 UTC
16-FEB-20 00.00.00.000000000 UTC
FFF
QDS

GHI
2
16-FEB-20 00.00.00.000000000 UTC
16-FEB-20 00.00.00.000000000 UTC
QDS
GGG

GHI
3
16-FEB-20 00.00.00.000000000 UTC
16-FEB-20 00.00.00.000000000 UTC
GGG
LLL


SELECT cat,
       TRUNC( change_date, 'MM' ) AS month,
       COUNT(*)
FROM   table_name
MATCH_RECOGNIZE(
  PARTITION BY cat
  ORDER BY "DATE", version
  MEASURES
    LAST( "DATE" ) AS change_date
  ONE ROW PER MATCH
  AFTER MATCH SKIP TO LAST change_code
  PATTERN ( strt change_code )
  DEFINE
    change_code AS (
      change_code.some_code <> strt.some_code
      AND MONTHS_BETWEEN( change_code."DATE", strt."DATE" ) <= 1
    )
)
GROUP BY cat, TRUNC( change_date, 'MM' )


CAT
MONTH
COUNT(*)


ABC
01-MAR-09
2

ABC
01-MAY-09
1

ABC
01-APR-09
2

DEF
01-FEB-18
1

GHI
01-FEB-20
3

CAT	MONTH	MN	CHANGE_FROM	CHANGE_TO
ABC	01-MAR-09	1	ZUM	MUZ
ABC	01-APR-09	1	XXX	UIO
DEF	01-FEB-18	1	FAW	WER
GHI	01-FEB-20	1	FFF	QDS
GHI	01-FEB-20	2	QDS	GGG
GHI	01-FEB-20	3	GGG	LLL

CAT	MN	FROM_DATE	TO_DATE	CHANGE_FROM	CHANGE_TO
ABC	1	19-FEB-09 00.00.00.000000000 UTC	18-MAR-09 00.00.00.000000000 UTC	OPP	ZUM
ABC	2	18-MAR-09 00.00.00.000000000 UTC	18-MAR-09 00.00.00.000000000 UTC	ZUM	MUZ
ABC	3	18-MAR-09 00.00.00.000000000 UTC	18-APR-09 00.00.00.000000000 UTC	MUZ	XXX
ABC	4	18-APR-09 00.00.00.000000000 UTC	18-APR-09 00.00.00.000000000 UTC	XXX	UIO
ABC	5	18-APR-09 00.00.00.000000000 UTC	18-MAY-09 00.00.00.000000000 UTC	UIO	RQA
DEF	1	16-FEB-18 00.00.00.000000000 UTC	17-FEB-18 00.00.00.000000000 UTC	FAW	WER
GHI	1	16-FEB-20 00.00.00.000000000 UTC	16-FEB-20 00.00.00.000000000 UTC	FFF	QDS
GHI	2	16-FEB-20 00.00.00.000000000 UTC	16-FEB-20 00.00.00.000000000 UTC	QDS	GGG
GHI	3	16-FEB-20 00.00.00.000000000 UTC	16-FEB-20 00.00.00.000000000 UTC	GGG	LLL

CAT	MONTH	COUNT(*)
ABC	01-MAR-09	2
ABC	01-MAY-09	1
ABC	01-APR-09	2
DEF	01-FEB-18	1
GHI	01-FEB-20	3