Oracle字符串拆分

原始字符串：a;b;c;d;e
拆分结果：
a
b
c
d
e
根据 ‘;’进行拆分。

处理SQL：

with t as  
 (select 'a;b;c;d;e' as str from dual)  
select level,  
       str,  
       regexp_substr(t.str, '[^;]+', 1, level) str_single
  from t  
connect by level <= length(t.str) - length(replace(t.str, ';', '')) + 1;  

原理：Oracle level 关键字