Oracle正则表达式分割字符串

select regexp_substr(b.columnName, '[^/]+', 1, c.lv) 
from (select regexp_count(a.columnName, '[^/]+') as cnt,a.columnName from tableName a ) b 
join (select level lv from dual connect by level <= 100) c on c.lv <= b.cnt

说明：此处按照 / 进行分割字符串，level <= 100默认分割包含100个 / 之内的字符串。