SQL> select substr(replace('a;a;b;b;c;d', ';', ''), level, 1)
2 from dual
3 connect by level <= length(replace('a;a;b;b;c;d', ';', ''));
SU
--
a
a
b
b
c
d
2 from dual
3 connect by level <= length(replace('a;a;b;b;c;d', ';', ''));
SU
--
a
a
b
b
c
d