Oracle 11g Release 2

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

CREATE TABLE YEARS (
    "FID" NUMBER(10,0) NOT NULL, 
	"I0" NUMBER(10,0) NOT NULL, 
	"BJA" NUMBER(10,0)
);
INSERT ALL
    INTO YEARS ("FID","I0","BJA") VALUES (1,0,1949)
    INTO YEARS ("FID","I0","BJA") VALUES (2,0,1996)
    INTO YEARS ("FID","I0","BJA") VALUES (3,0,1970)
    INTO YEARS ("FID","I0","BJA") VALUES (4,1,1871)
    INTO YEARS ("FID","I0","BJA") VALUES (4,0,1975)
    INTO YEARS ("FID","I0","BJA") VALUES (5,0,1967)
    INTO YEARS ("FID","I0","BJA") VALUES (6,0,1968)
    INTO YEARS ("FID","I0","BJA") VALUES (7,0,1926)
    INTO YEARS ("FID","I0","BJA") VALUES (7,1,2009)
    INTO YEARS ("FID","I0","BJA") VALUES (7,2,2012)
    INTO YEARS ("FID","I0","BJA") VALUES (7,3,2018)
    INTO YEARS ("FID","I0","BJA") VALUES (8,0,1956)
    INTO YEARS ("FID","I0","BJA") VALUES (9,0,1990)
    INTO YEARS ("FID","I0","BJA") VALUES (10,0,1953)
    INTO YEARS ("FID","I0","BJA") VALUES (10,1,1904)
    
SELECT 1 FROM dual;
15 rows affected

SELECT
  FID
, CONSTRYEAR
, LISTAGG(NULLIF(BJA, CONSTRYEAR), ', ') WITHIN GROUP (ORDER BY BJA ASC) AS RECONSTRYEAR
FROM
  (
    SELECT
      YEARS.*
    , MIN(BJA) OVER (PARTITION BY FID) AS CONSTRYEAR
    FROM
      YEARS
  )
GROUP BY
  FID
, CONSTRYEAR
;


FID
CONSTRYEAR
RECONSTRYEAR


1
1949
null

2
1996
null

3
1970
null

4
1871
1975

5
1967
null

6
1968
null

7
1926
2009, 2012, 2018

8
1956
null

9
1990
null

10
1904
1953

FID	CONSTRYEAR	RECONSTRYEAR
1	1949	null
2	1996	null
3	1970	null
4	1871	1975
5	1967	null
6	1968	null
7	1926	2009, 2012, 2018
8	1956	null
9	1990	null
10	1904	1953