Oracle 21c

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

CREATE TABLE Cars (
    Car_ID INT,
    Car_Name VARCHAR(50),
    Owner VARCHAR(50)
);


INSERT INTO Cars (Car_ID, Car_Name, Owner) VALUES (1, 'Ferrari', 'Marco');
1 rows affected

INSERT INTO Cars (Car_ID, Car_Name, Owner) VALUES (2, 'Jeep', 'Enrico');
1 rows affected

INSERT INTO Cars (Car_ID, Car_Name, Owner) VALUES (3, 'Mercedes', 'Matteo');
1 rows affected

INSERT INTO Cars (Car_ID, Car_Name, Owner) VALUES (1, 'Ferrari', 'Andrea');
1 rows affected

INSERT INTO Cars (Car_ID, Car_Name, Owner) VALUES (3, 'Mercedes', 'Giorgio');
1 rows affected

INSERT INTO Cars (Car_ID, Car_Name, Owner) VALUES (2, 'Jeep', 'Gianluca');
1 rows affected

select Car_ID,Car_Name,listagg(Owner,',') as Owners from Cars
group by Car_ID,Car_Name


CAR_ID
CAR_NAME
OWNERS


3
Mercedes
Matteo,Giorgio

1
Ferrari
Marco,Andrea

2
Jeep
Enrico,Gianluca

CAR_ID	CAR_NAME	OWNERS
3	Mercedes	Matteo,Giorgio
1	Ferrari	Marco,Andrea
2	Jeep	Enrico,Gianluca