SQL代码:

\"\"\"\"
SELECT t.*
FROM pt_org_info t
START WITH t.id = 1
CONNECT BY t.par_id = PRIOR t.id
ORDER SIBLINGS BY t.id;
View Code

 效果图:

\"\"

 

收藏 打印