QUOTE:

---

原帖由 grubbyoo 于 2008-9-18 09:44 发表
create table tmp5 (id number(2),name varchar2(10),code varchar2(50));

insert into tmp5 values (1,'aaa','c001/c002/c007');
insert into tmp5 values (2,'bbb','c001/c003');
insert into tmp5 values (3,'ccc','c008/c0011/c029/c023');
insert into tmp5 values (4,'ddd','c102/c111/c112/c144/c167');

commit

select a.*,regexp_substr(a.code,'[^/]+',1,b.n)
from tmp5 a,
     (select rownum n from dual connect by rownum=b.n

---

QUOTE:

---

原帖由 guoq.lee 于 2008-9-18 15:33 发表



学习了。

要是按下面这样写一定是错的，但是没看出来究竟是因为什么错的？
select a.*,regexp_substr(a.code,'[^/]+',1,level),level
from tmp5 a
connect by level

---