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;