leezw03 发表于 2013-1-29 15:16:24

Oracle将一行数据，通过逗号转成多行

select dbms_lob.substr (regexp_substr('abc,def,ggg,1,2,3,4,5', '[^,]+', 1, x.n)) as player_guid from dual a, (select rownum n from dual connect by rownum < 100) x
页: [1]
查看完整版本: Oracle将一行数据，通过逗号转成多行