WITH t(地区,品牌) AS(
SELECT '美国','沃尔玛' FROM dual
UNION ALL
SELECT '美国','福特' FROM dual
UNION ALL
SELECT '美国','英特尔' from dual
UNION ALL
SELECT '美国','苹果' from dual
UNION ALL
SELECT '中国','华为' from dual
UNION ALL
SELECT '中国','创维' from dual
UNION ALL
SELECT '韩国','三星' from dual
UNION ALL
SELECT '韩国','现代' from dual
UNION ALL
SELECT '韩国','LG' from dual
)
SELECT 地区,listagg(品牌,'/')WITHIN GROUP (ORDER BY ROWNUM) FROM t
GROUP BY 地区;