SQL> WITH test
  2          AS (SELECT 108 c_name, 'test' c_project, 'err1,err2,err3' c_error
  3                FROM DUAL
  4              UNION
  5              SELECT 109, 'test2', 'err1' FROM DUAL)
  6    SELECT c_name,
  7           c_project,
  8           REGEXP_SUBSTR (c_error,
  9                          '[^,]+',
 10                          1,
 11                          x.COLUMN_VALUE)
 12              one_Error
 13      FROM test t,
 14           TABLE (
 15              CAST (
 16                 MULTISET (
 17                        SELECT LEVEL lvl
 18                          FROM DUAL
 19                    CONNECT BY LEVEL <=
 20                                    1
 21                                  + LENGTH (c_error)
 22                                  - LENGTH (REPLACE (c_error, ',', ''))) AS SYS.
 23                                                                             odcinumberlist)) x
 24  ORDER BY c_name, c_project, one_error;

    C_NAME C_PRO ONE_ERROR
---------- ----- --------------
       108 test  err1
       108 test  err2
       108 test  err3
       109 test2 err1

SQL>

SQL> WITH T AS
  2    ( SELECT 1 ID, 'ERR1, ERR2, ERR3' AS ERR FROM DUAL
  3    UNION ALL
  4    SELECT 2 ID, 'ERR4, ERR5' FROM DUAL
  5    )
  6  SELECT ID,
  7    TRIM(REGEXP_SUBSTR(ERR, '[^,]+', 1, RN)) NEW_ERR
  8  FROM T,
  9    (SELECT LEVEL RN
 10    FROM DUAL
 11      CONNECT BY LEVEL<=
 12      (SELECT MAX(LENGTH(REPLACE(ERR, ',', ''))) FROM T
 13      )
 14    )
 15  WHERE REGEXP_SUBSTR(ERR, '[^,]+', 1, RN) IS NOT NULL
 16  ORDER BY 1, 2;

        ID NEW_ERR
---------- ----------------
         1 ERR1
         1 ERR2
         1 ERR3
         2 ERR4
         2 ERR5

SQL>

SQL> WITH T AS
  2        ( SELECT 1 ID, 'ERR1, ERR2, ERR3' AS ERR FROM DUAL
  3       UNION ALL
  4        SELECT 2 ID, 'ERR4, ERR5' FROM DUAL
  5        UNION ALL
  6        SELECT 3 ID, 'ERR6,, , , , ERR11' FROM DUAL
  7       )
  8  SELECT id,TRIM(REGEXP_SUBSTR(err,'[^,]+',1,rn)) s_err
  9    FROM (SELECT t.*,LENGTH(err)-LENGTH(REPLACE(err,','))+1 cnt
 10            FROM t
 11          )
 12        ,(SELECT ROWNUM rn FROM DUAL CONNECT BY ROWNUM<=100)
 13  WHERE RN<=CNT
 14  ORDER BY 1;

        ID S_ERR
---------- ------------------
         1 ERR1
         1 ERR2
         1 ERR3
         2 ERR4
         2 ERR5
         3 ERR11
         3 ERR6
         3
         3
         3
         3

11 rows selected.