oracle如何拆分以指定字符分隔为多行!
with t as
(select '111.222.333' col
from dual
union all
select '444.555.666' col
from dual)
select regexp_substr(col, '[^.]+', 1, level)
from t
connect by level <= regexp_count(col, '\.\') + 1
and col = prior col
and prior dbms_random.value > 0
本文来自发现别的人评论,评论人博客:https://blog.csdn.net/weixin_43125677