oracle 分割字符串(3)

  with t as (select ',123,43,567,'str from dual)
select substr(t.str,instr(t.str,',',1,rownum)+1,instr(t.str,',',1,rownum+1)-instr(t.str,',',1,rownum)-1)Id
  from dual,t
   connect by rownum<length(t.str)-length(replace(t.str,',',''))

评论

1 楼 萧萧一剑 2012-02-01  

很好的语句啊，楼主是人才啊