oracle/db8 按字段值分割成多条记录

SELECT
	id,
	DIRECTOR,
	REGEXP_SUBSTR(DIRECTOR,
	'[^,]+',
	1,
	LEVEL) AS NEW_
FROM
	PRO_TASK_TREE
WHERE
	DIRECTOR IS NOT NULL
CONNECT BY
	PRIOR id = id
	AND PRIOR DBMS_RANDOM.VALUE IS NOT NULL
	AND LEVEL <= LENGTH(DIRECTOR) - LENGTH(REPLACE(DIRECTOR, ',', '')) + 1;