================ sql 轉換 查詢出多行數據================

(select t.PROPERTY from JD_CODING t left join  DELIVERY_OF c on t.VALUE = c.TYPE where t.PROPERTY = 'stackingType' group by t.PROPERTY)

================ 更改后 轉為一列的拼接字符串================

 ( select listagg( distinct t.PROPERTY,',')   within group (  order by t.PROPERTY  ) from JD_CODING t left join DELIVERY_OF c on t.VALUE = c.TYPE where t.PROPERTY = 'stackingType')

SELECT LISTAGG (name, ',') WITHIN GROUP (ORDER BY name)  FROM 。。。。

感謝老哥:https://www.modb.pro/issue/16516

感謝老哥:https://www.5axxw.com/questions/simple/mstqdk