SELECT
Sys_Connect_By_Path(Dept_Id,'|'),
t.dept_tree,
t.dept_id
FROM
C##.Sa_Dept t
START WITH Dept_Id = '10000'
CONNECT BY PRIOR DEPT_ID = P_DEPT_ID;
Sys_Connect_By_Path(Dept_Id,'|'),
t.dept_tree,
t.dept_id
FROM
C##.Sa_Dept t
START WITH Dept_Id = '10000'
CONNECT BY PRIOR DEPT_ID = P_DEPT_ID;