Converting Comma separated string to Rows using SQL

WITH rws AS (SELECT ',Bala,Mithu,Achu,Comma,' str FROM DUAL)
    SELECT REGEXP_SUBSTR (str, '[^,]+', 1, LEVEL) VALUE
      FROM rws
CONNECT BY LEVEL <= LENGTH (TRIM (BOTH ',' FROM str)) - LENGTH (REPLACE (str, ',')) + 1;

Script Output

VALUE

---------------

Bala

Mithu

Achu

Comma