orcale截取字符串并分组和顺序号

--截取字符串并分组和顺序号[1,2,3,4...]

select distinct 

--截取字符串并分组[

--4112AE37061C4D528495E4FB32CFD8BA,8A5799781BF24777A7DE4739B8EF9F76,

--DC5C8577EB484F1185CF388B690B98E7]

regexp_substr('4112AE37061C4D528495E4FB32CFD8BA,

8A5799781BF24777A7DE4739B8EF9F76,DC5C8577EB484F1185CF388B690B98E7','[^,]+',1,level) str,

--生成顺序号[1,2,3,4...] bg_bgzsx ：表名，bzsdid :ID ,plsx :字段排序

((select (select * from (select  count(1)  from bg_bgzsx where bzsdid ='2' order by plsx desc) where  rownum < 2) as ss from dual)+ROWNUM) num

 from  dual 

connect by regexp_substr

('4112AE37061C4D528495E4FB32CFD8BA,8A5799781BF24777A7DE4739B8EF9F76,DC5C8577EB484F1185CF388B690B98E7','[^,]+',1,level) is not null order by 1;

//字符串拆分 zrr 为数据字段

select distinct regexp_substr(zrr,'[^,]+',1,level) str from  dual connect by regexp_substr (zrr,'[^,]+',1,level) is not null order by 1;