SELECT * FROM (SELECT TO_CHAR(a.pdjkdxid),c.runno m ,b.runno n FROM T_PDJKDX a ,T_PDXLGGL b,T_PDXLGGL c
WHERE a.pdxlid=14197351534680891662 AND a.plx_bid=b.pdt_id AND a.plx_eid=c.pdt_id)
START WITH n = '1'
CONNECT BY PRIOR m =n /*M是一段线的终点, N是一段线的起点*/
WHERE a.pdxlid=14197351534680891662 AND a.plx_bid=b.pdt_id AND a.plx_eid=c.pdt_id)
START WITH n = '1'
CONNECT BY PRIOR m =n /*M是一段线的终点, N是一段线的起点*/