oracle 列转行

SELECT

    REGEXP_SUBSTR (skills_certificate_number, '[^,]+', 1, lv) skills_certificate_number,
     REGEXP_SUBSTR (skil, '[^,]+', 1, lv) skil,
      REGEXP_SUBSTR (skill_level, '[^,]+', 1, lv) skill_level

FROM
    T_OWS_CANVAS_USER,
    
    (
        SELECT
            LEVEL lv
        FROM
            dual CONNECT BY LEVEL < 100
    ) b

WHERE
     T_OWS_CANVAS_USER.id_no='120101198208102555'

with t as (
select q.* from(
select y.skills_certificate_number ,y.skil,y.skill_level
from T_OWS_CANVAS_USER y 
where y.id_no='120101198208102555'
) q 
)
select regexp_substr(t.skills_certificate_number, '[^,]+',1,level) as skills_certificate_number,
regexp_substr(t.skill_level, '[^,]+',1,level) as skill_level,
regexp_substr(t.skil, '[^,]+',1,level) as skil
from t 
connect by level <= length(t.skil) - length(t.skill_level)

 (
            with t as (
            select q.* from(
            select y.*
            from t_ows_compelete_rfc y 
         
             where y.status='Closed' and y.operation_status='Completed Success' 
            ) q 
            )
            select (case when  regexp_like(t.implementer,';') then   regexp_substr(t.implementer, '[^;]', 1, rownum)  
                         when  regexp_like(t.implementer,',') then   regexp_substr(t.implementer, '[^,]', 1, rownum)  
                    else t.implementer end ) implementer,
                   t.severity,
                   t.request_type,
                   t.rfc_rep_office,
                   t.l1_assignee,
                   t.urgency,
                   t.status,
                   t.operation_status
            from t 
            connect by level <=1

两种写法