with t as (select '1,2,32,444,F,A' str,',' delimiter from dual)
select *
  fromt, table(cast(multiset(select regexp_substr(t.str,'[^'||t.delimiter||',]+',1,level) -- с 10g
                                          from dual
                                      connect by level<= regexp_count(t.str, ',')) as sys.odcivarchar2list)
) substring

  select distinct regexp_substr(t.str, '[^,]+',1,level)
    from some_table
connect by level<= regexp_count(t.str, ',')

SQL> select * from t;

        ID N
---------- ------------------------------
         1 1,2,3,33,aa
         2 3,5,7,ss,666

SQL> select --distinct
  2    id
  3   ,level l
  4   ,regexp_substr(t.n, '[^,]+',1,level) r
  5  from t
  6       connect by level<= regexp_count(t.n, ',')+1
  7   and rowid=prior rowid
  8   and prior sys_guid() is not null
  9  /

        ID          L R
---------- ---------- ------------------------------
         1          1 1
         1          2 2
         1          3 3
         1          4 33
         1          5 aa
         2          1 3
         2          2 5
         2          3 7
         2          4 ss
         2          5 666

10 rows selected.

SQL>