/*
某产品加工工序
当前工序,下个工序
A05,A06
A06,A07
A10,A11
A11,A12
A12,A05
用oracle-sql,求工序的顺序清单
>>> sort >>
A10
A11
A12
A05
A06
A07
*/
create table test
(
aaa varchar2(10)
,bbb varchar2(10)
)
insert into test values('A05','A06');
insert into test values('A06','A07');
insert into test values('A10','A11');
insert into test values('A11','A12');
insert into test values('A12','A05');
insert into test values('A13','A14');
--insert into test values('A14','A15');
--insert into test values('A15','A01');
--insert into test values('A01','A02');
--insert into test values('A02','A03');
commit;
解决办法:
select aaa
from test
start with aaa=(
select aaa
from test
where aaa not in(select bbb from test))
connect by prior bbb=aaa
union all
select bbb
from test
where bbb not in(select aaa from test);
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/101162/viewspace-1007689/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/101162/viewspace-1007689/