Oracle 23c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
0


CREATE TABLE test (
    col0 NUMBER,
    col1 NUMBER
);
INSERT ALL
    INTO test (col0, col1) VALUES (1, 7)
    INTO test (col0, col1) VALUES (1, 8)
    INTO test (col0, col1) VALUES (1, 8)
    INTO test (col0, col1) VALUES (1, 2)
    INTO test (col0, col1) VALUES (1, 9)
    INTO test (col0, col1) VALUES (2, 9)
    INTO test (col0, col1) VALUES (3, 10)
    INTO test (col0, col1) VALUES (3, 11)
    INTO test (col0, col1) VALUES (3, 12)
SELECT * FROM dual;
9 rows affected

select * from test;


COL0
COL1


1
7

1
8

1
8

1
2

1
9

2
9

3
10

3
11

3
12


SELECT col0,
       LISTAGG(DISTINCT col1, ',') WITHIN GROUP (ORDER BY col1) AS col1
FROM test
GROUP BY col0;


COL0
COL1


1
2,7,8,9

2
9

3
10,11,12