select element_id,element_name,dc_id,dc_name from NEPUBDB.XNYZCDB.GRAPHELEMENT where dc_id='lnxhwj' CONNECT BY element_id= PRIOR element_pid START WITH element_id='DingHorizontalBusbar_1'
应该首先在内部select中使用where子句筛选
select element_id,element_name,dc_id,dc_name from
(
select element_id,element_name,dc_id,dc_name from NEPUBDB.XNYZCDB.GRAPHELEMENT
where dc_id='lnxhwj'
) CONNECT BY element_id= PRIOR element_pid START WITH element_id='DingHorizontalBusbar_1'
connect by错误的解决办法如果数据表里面有多棵树,而且多棵树的链接字段有可能重名,极有可能发生“用户数据中的connect by 循环错误“解决办法是加where子句筛选出一棵树再用connect by语句然而,下面这种写法是错误的select element_id,element_name,dc_id,dc_name from NEPUBDB.XNY