oracle 查询结果用逗号分割成多行

 with tmp as (  
                          select t.*,  
                                 length(ATTACH_LABEL_CODE)-length(regexp_replace(ATTACH_LABEL_CODE, ',', ''))+1 len  
                            from dev_bitem_file_relation  t where ATTACH_LABEL_CODE is not null
                          )  
                          select file_id, regexp_substr(ATTACH_LABEL_CODE, '[^,]+', 1, rn) ATTACH_LABEL_CODE  
                            from tmp a, (select rownum rn from dual connect by level <= (select max(len) from tmp x)) b  
                           where a.len>=b.rn