SELECT ORDER_ID,LTRIM(MAX(SYS_CONNECT_BY_PATH(GOODS_NAME, ',')), ',') GOODS_NAME
FROM (SELECT GOODS_NAME,ORDER_ID, ROW_NUMBER() OVER(PARTITION BY ORDER_ID ORDER BY GOODS_NAME DESC) RN
FROM 表名)
START WITH RN = 1
CONNECT BY RN - 1 = PRIOR RN
AND ORDER_ID = PRIOR ORDER_ID
GROUP BY ORDER_ID