Oracle 根据逗号拆分字段内容转成多行的函数说明

SELECT DISTINCT A.*, REGEXP_SUBSTR(A.DEPT_CODE, '[^,]+' , 1, Level , 'i' )
   FROM ( SELECT *
           FROM APP_TEMPLATE_DEPT T
          WHERE T.EVALUATE_INDEX_CODE = '3330326' ) A
CONNECT BY Level <= LENGTH(A.DEPT_CODE) -
            LENGTH(REGEXP_REPLACE(A.DEPT_CODE, ',' , '' )) + 1;