LISTAGG使用

SELECT LISTAGG(fun_getaaa103('AAE140', a.aae140), ',') WITHIN GROUP(ORDER BY a.aae140) AS aae140str
  FROM ac02 a
 where a.aac001 = '10002070436';

SELECT * FROM ac02 a where a.aac001 = '10002070436';      

查詢結果：