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