您可以使用LISTAGG函数，但如果不使用ORDER BY子句，则连接乘积的顺序是 * 不确定的 *。所以你需要有一个列来标识你的产品的顺序。您可以创建一个表或使用CTE来让您的 * 特定订单 * 然后与您的表连接，如下所示：

WITH products_order(PRODUCT, p_ord) AS
(
  SELECT 'Bananas' AS PRODUCT, 1 AS p_ord FROM dual UNION ALL
  SELECT 'Oranges' AS PRODUCT, 2 AS p_ord FROM dual UNION ALL
  SELECT 'Apples' AS PRODUCT, 3 AS p_ord FROM dual 
)
SELECT A.ID, A.PRODUCT,
   LISTAGG(DISTINCT CASE WHEN A.PRODUCT <> 'Other' THEN A.PRODUCT END, ', ') 
    WITHIN GROUP (ORDER BY O.p_ord) OVER (PARTITION BY A.ID) AS Product_Concat
FROM Acc A JOIN products_order O
ON A.PRODUCT = O.PRODUCT
ORDER BY A.ID, O.p_ord

Demo