Comma Delimiter string to Table in sql or plsql oracle

Ex:

 select regexp_substr('SW14590,SW14590,SW9797,EX98797,AS9822','[^,]+', 1, level) Col from dual
  connect by regexp_substr('SW14590,SW14590,SW9797,EX98797,AS9822', '[^,]+', 1, level) is not null

OUTPUT:

COL
SW14590
SW14590
SW9797
EX98797
AS9822