auf1r2,
WITH t AS (
SELECT 'Russian' a, 'Igor' b FROM dual UNION ALL
SELECT 'Russian' a, 'Vasia' b FROM dual UNION ALL
SELECT 'Russian' a, 'Petya' b FROM dual UNION ALL
SELECT 'Bananas' a, 'Alibaba1' b FROM dual UNION ALL
SELECT 'Bananas' a, 'Alibaba2' b FROM dual UNION ALL
SELECT 'Bananas' a, 'Alibaba3' b FROM dual
)
SELECT a, wm_concat(b)
FROM t
GROUP BY a
А про либо другую функцию не wm_concat , если 11г тыды concatlist.