I have no experience with Oracle so this from search work and is not tested.
I found the
LISTAGG[
^] statement, which should be available from Oracle 10g.
You statement would look like
SELECT u.name, r.region, LISTAGG(r.office, ' ') WITHIN GROUP (ORDER BY NULL)
FROM user u
JOIN region r on u.regionID = r.regionID
GROUP BY u.name, r.region
ORDER BY 1, 2 NULLS LAST
I have taken this from
Oracle LISTAGG function [
^].