select t3.id from table t3
where EXISTS (select t5.id, t5.od
from (SELECT distinct(a11.id), b11.OD
FROM table a11,
(SELECT t11.id,t11.od,t11.name
FROM table t11
START WITH t11.id = '298001'
CONNECT BY PRIOR t11.id = t11.parentid) b11
WHERE a11.name = b11.name || '中文') t5
where t3.id = t5.id)
运行的时候不报错,就一直执行。。
where EXISTS (select t5.id, t5.od
from (SELECT distinct(a11.id), b11.OD
FROM table a11,
(SELECT t11.id,t11.od,t11.name
FROM table t11
START WITH t11.id = '298001'
CONNECT BY PRIOR t11.id = t11.parentid) b11
WHERE a11.name = b11.name || '中文') t5
where t3.id = t5.id)
运行的时候不报错,就一直执行。。
--应该是这里的问题,仔细查查这个地方写的有没有问题。
SELECT t11.id,t11.od,t11.name
FROM table t11
START WITH t11.id = '298001'
CONNECT BY PRIOR t11.id = t11.parentid