SELECT DISTINCT REGEXP_SUBSTR ('A-1,B-2,C-3,D-4','[^,]+',1,LEVEL) as "result"
FROM DUAL
CONNECT BY REGEXP_SUBSTR ('A-1,B-2,C-3,D-4','[^,]+',1,LEVEL) IS NOT NULL
order by 1
Oracle sql 实现查询时将一个字符串按照","逗号分隔,返回分隔后的各个值
最新推荐文章于 2024-06-25 17:19:55 发布
SELECT DISTINCT REGEXP_SUBSTR ('A-1,B-2,C-3,D-4','[^,]+',1,LEVEL) as "result"
FROM DUAL
CONNECT BY REGEXP_SUBSTR ('A-1,B-2,C-3,D-4','[^,]+',1,LEVEL) IS NOT NULL
order by 1