oracle拆分字符串

SELECT REGEXP_SUBSTR(FUNC_plan_projectpage(#planUuid#,A.F_PROUUID), '[^,]+', 1, LEVEL, 'i') AS STR
FROM DUAL
CONNECT BY LEVEL <=
LENGTH(FUNC_plan_projectpage(#planUuid#,A.F_PROUUID)) - LENGTH(REGEXP_REPLACE(FUNC_plan_projectpage(#planUuid#,A.F_PROUUID), ',', ''))+1

将字符串拆分成数组