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
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
解决方案 »
- OracleDBConsoleorcl服务启动不了。
- 求插入时间的SQL语句!!!
- ORA-01653: unable to extend table CAT_TRAN_HISTORIES by 8497 in tablespace DAT
- 真正的高手题,100分狂撒!
- 菜鸟级问题,安装oracle透明网关,没找到安装目录……
- 关于物化视图的影响
- 关于hint问题的咨询
- oracle数据库安全审计问题,求教!
- ORACLE数据库的乱码问题!!急!!急!
- Window2000 server版上,是否可以同时安装Oracle8.05与Oracle9.i不同版本的数据库
- Oracle多次分组问题
- 为什么cmd能运行javac,不能运行java
where 1 in (select 1 from dual@dblink)
start with 1 = 1
connect by level < 1语法上可以,没看出你想问什么