Oracle LISTAGG

For a specified measure, LISTAGG orders data within each group specified in the ORDER BY clause and then concatenates the values of the measure column.
Example:

SELECT 
--old KZ_ID
LISTAGG(KZ_ID, ', ') WITHIN GROUP (ORDER BY KZ_ID) 
FROM TAHO.MV_KOSTST WHERE GB_LZN=46;

list_agg