select connect_by_root(t1.id),
id
from tab1 t1
where t1.pid in(select id from work)
start with t1.pid is null
connect by prior t1.id = t1.pid
查找 work的ID下所有的節點，報錯：不能在遠程資料庫鏈接使用start with子查詢
而這樣寫是沒有問題的
select connect_by_root(t1.id),
id
from tab1 t1
where t1.pid in(1,2,3,4,5,6,)
start with t1.pid is null
connect by prior t1.id = t1.pid
uj5u.com熱心網友回復：
select*from dual
where 1 in (select 1 from dual@dblink)
start with 1 = 1
connect by level < 1
語法上可以，沒看出你想問什么
uj5u.com熱心網友回復：
你用到DBLINK了吧。uj5u.com熱心網友回復：
對，t1用的是DBLINK轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/28112.html
標籤：開發
上一篇：資料庫運維
下一篇：最后的歲月--陪伴媽媽