oracle正则表达式(二)
with t as (select '/ho;ih;o;gfA/B12/54D/Gfgh' tt from dual)select level rn,regexp_substr(tt, '[^/]+', 1, level)from tconnect by regexp_instr(tt, '[^/]+', 1, level) > 0 ho;ih;o;gfAB1254DGfgh...
注册时间:2011-02-09