Oracle字段根据逗号分割查询数据的方法

select * from ( select guid, regexp_substr(st_responsible, ‘[^,]+‘, 1, level) responsible   from tt_cancle_responsible   connect by level <= regexp_count(st_responsible, ‘,‘) + 1  and guid = prior guid  and prior dbms_random.value is not null )where responsible =‘wyy‘;