guanjm(st.human) 要针对这个表你答的没错,要是随便加一行 m , n, 300 就不对了
也是对的 你加上 m,n,300 按照你的要求 也是a所到达不了的呀.
我的就是正确答案啊: 用 connect by.select distinct ends from xianlu t connect by t.starts = prior t.ends start with t.starts = 'a' order by ends注释:starts 起点, ends 终点,
select distinct ends from xianlu t connect by t.starts = prior t.ends start with t.starts = 'a' order by ends ----------------------------- 我查过了,oracle10g还有connect_by_root 直接查最终节点,强
connect by t.starts = prior t.ends start with t.starts = 'a' order by ends 这个8i支持吗,很好的东东,没有见过啊
from xianlu t
connect by t.starts = prior t.ends
start with t.starts = 'a'
order by ends注释:starts 起点, ends 终点,
比如说:
a-b
b-c
a-c
这种情况是可以的
但下面这种情况会出错
a-b
b-c
c-a
要针对这个表你答的没错,要是随便加一行 m , n, 300
就不对了
你加上 m,n,300
按照你的要求 也是a所到达不了的呀.
用 connect by.select distinct ends
from xianlu t
connect by t.starts = prior t.ends
start with t.starts = 'a'
order by ends注释:starts 起点, ends 终点,
from xianlu t
connect by t.starts = prior t.ends
start with t.starts = 'a'
order by ends
-----------------------------
我查过了,oracle10g还有connect_by_root 直接查最终节点,强
start with t.starts = 'a'
order by ends
这个8i支持吗,很好的东东,没有见过啊
不过也可以自己写绨归的实现。