照着下面SQL修改吧,这是SELECT的,如果是UPDATE,可以自己调整
SELECT 唯一字段,
LISTAGG(COLUMN_DISTINCT, ',') WITHIN GROUP(ORDER BY COLUMN_DISTINCT) AS 去重字段
FROM (SELECT DISTINCT 唯一字段, COLUMN_DISTINCT
FROM (SELECT 唯一字段,
REGEXP_SUBSTR(去重字段, '[^,]+', 1, lv) COLUMN_DISTINCT
FROM table,
(SELECT LEVEL lv FROM dual CONNECT BY LEVEL < 10) b
WHERE b.lv <= REGEXP_COUNT(去重字段, '\,') + 1
ORDER BY 唯一字段))
GROUP BY 唯一字段;