一.没有去重没有排序的分割。
SELECT REGEXP_SUBSTR ('A,B,B,C,D,E','[^,]+',1,LEVEL) as "分割"
FROM DUAL
CONNECT BY REGEXP_SUBSTR ('A,B,B,C,D,E','[^,]+',1,LEVEL) IS NOT NULL
二.分割去重。
SELECT DISTINCT REGEXP_SUBSTR ('A,B,B,C,D,E','[^,]+',1,LEVEL) as "分割"
FROM DUAL
CONNECT BY REGEXP_SUBSTR ('A,B,B,C,D,E','[^,]+',1,LEVEL) IS NOT NULL
order by 1
三.使用TRANSLATE替换字符串中的指定字符
select TRANSLATE('A-B-C-D', '-', ',') as 替换 from dual
