树形查询
树形查询
create table test(
bm number(8),
bmmc varchar2(20),
sjbm number(8)
);
insert into test values(1,'aaa',0);
insert into test values(11,'aaa1',1);
insert into test values(12,'aaa2',1);
insert into test values(111,'aaa11',11);
insert into test values(112,'aaa12',11);
insert into test values(113,'aaa13',11);
insert into test values(121,'aaa21',12);
insert into test values(122,'aaa22',12);
insert into test values(123,'aaa23',12);
--
select bm,bmmc,sjbm,level
from zj
start with sjbm=0
connect by prior bm = sjbm;
或者
select bm,bmmc,sjbm,level
from zj
start with sjbm=0
connect by sjbm = prior bm;
create table test(
bm number(8),
bmmc varchar2(20),
sjbm number(8)
);
insert into test values(1,'aaa',0);
insert into test values(11,'aaa1',1);
insert into test values(12,'aaa2',1);
insert into test values(111,'aaa11',11);
insert into test values(112,'aaa12',11);
insert into test values(113,'aaa13',11);
insert into test values(121,'aaa21',12);
insert into test values(122,'aaa22',12);
insert into test values(123,'aaa23',12);
--
select bm,bmmc,sjbm,level
from zj
start with sjbm=0
connect by prior bm = sjbm;
或者
select bm,bmmc,sjbm,level
from zj
start with sjbm=0
connect by sjbm = prior bm;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/756652/viewspace-242054/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
ORACLE VPD方案
请登录后发表评论
登录
全部评论
