Oracle 拆分字段为行,REGEXP_SUBSTR函数使用笔记记录
函数详细说明请自行百度、Google
查询SQL示例
with t as
(select '312,564' str, 2 lvl from dual
union all
select '123,456,789' str, 3 lvl from dual
)
select REGEXP_SUBSTR(str ,'[^,]+', 1, level), lvl STR
from ...
原创
2019-06-27 10:26:32 ·
816 阅读 ·
0 评论