原创

connect by prior 递归算法 - 查找根ID

SELECT * FROM ISC_BASEORG T START

WITH T.SYSDATAID='9161AE3FDC9A20D2E0437F00000120D2' 

CONNECT BY PRIOR T.PARENT_ID=T.ID

正文到此结束
本文目录