Pipe Delimiter string to Table

Sql:


 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

Reference:

http://psoug.org/reference/regexp.html