huzige0265

导航

 

SELECT trim(regexp_substr(str, '[^,]+', 1, level)) strRows
FROM (SELECT '12,1321,1234' as str from dual) t
CONNECT BY instr(str, ',', 1, level - 1) > 0

posted on 2020-02-11 17:50  huzige0265  阅读(200)  评论(0编辑  收藏  举报