Oracle 9 xmlagg() 函數將多筆資料合併在同一列上

WITH qa AS
     (SELECT 'Row1' drow, 'user1' emp, 100 num  FROM DUAL
      UNION ALL
      SELECT 'Row2' drow, 'user1' emp, 90 num   FROM DUAL
      UNION ALL
      SELECT 'Row3' drow, 'user1' emp, 80 num   FROM DUAL)
SELECT   emp,
         RTRIM (XMLAGG (XMLELEMENT ("User", num || ',') order by num ).EXTRACT ('//text()'),',') combine
    FROM qa
GROUP BY emp;

參照
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/functions169a.htm