一字段含有逗号分隔的串，如何把这条记录按分隔符分成多

CREATE TABLE T_INFO
(
       T_PERSON_ID NUMBER,
       T_PERSON_NAME VARCHAR(20),
       T_TYPE_ID VARCHAR(200)
);
INSERT INTO T_INFO 
SELECT 1, '张三', '1,2' FROM DUAL UNION ALL 
SELECT 2, '李四', '1' FROM DUAL






select distinct T_PERSON_ID,
       T_PERSON_NAME,
       regexp_substr(T_TYPE_ID, '[^,]+', 1, level) T_TYPE_ID
  from t_info
connect by level <= length(T_TYPE_ID)-length(regexp_replace(T_TYPE_ID,  ',', '')) + 1
       and T_TYPE_ID = prior T_TYPE_ID
       and prior dbms_random.value is not null;
----------------------------------------------------------------------------------


select distinct gc_tcjh_xmcbk_id,
                xmmc,
                regexp_substr(qy, '[^,]+', 1, level) qy
  from gc_tcjh_xmcbk
connect by level <= length(qy) - length(regexp_replace(qy, ',', '')) + 1
       and qy = prior qy
       and prior dbms_random.value is not null;