oracle逗号拆分

xiaoxiao2021-02-28  82

select replace(regexp_substr(c2, '[^,]+', 1, level), ',', ' ') c2       from (select '961,963,2013' c2 from dual) t1     connect by level <= length(c2) - length(replace(c2, ',', '')) + 1
转载请注明原文地址: https://www.6miu.com/read-68772.html

最新回复(0)