For help, a great god! The SQL can change-CodePudding

The select connect_by_root (t1. Id),
Id
The from tab1 t1
Where t1. Pid in (select id from work)
Start with t1. Pid is null
Connect by the prior t1. Id=t1. Pid

Search for the work of all nodes under the ID, an error: cannot be used in remote database links start with subqueries
And this is no problem of
The select connect_by_root (t1. Id),
Id
The from tab1 t1
6, where t1. Pid in ()
Start with t1. Pid is null
Connect by the prior t1. Id=t1. Pid

CodePudding user response:

 select * from dual 
Where 1 in (select 1 from dual @ dblink) 
Start with 1=1 
Connect by level & lt; 1

Grammar can't see what you want to ask

CodePudding user response:

You use DBLINK.

CodePudding user response:

Yes, t1 with DBLINK