将字符串按固定字符切割为多行

SELECT REGEXP_SUBSTR('123:345:432', '[^:]+', 1, rownum)
  from dual
connect by rownum <= REGEXP_COUNT('123:345:432', ':') + 1;