一列字符拆解成多行

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