SELECT ZSD.DEPTID,ZSD.DEPTCODE,ZSD.DEPTDESCR,ZSD.DEPTPID FROM ZMD_SYS_DEPT ZSD
CONNECT BY PRIOR ZSD.DEPTPID = ZSD.DEPTID START WITH ZSD.DEPTCODE='FACTORY'
SELECT ZSD.DEPTID,ZSD.DEPTCODE,ZSD.DEPTDESCR,ZSD.DEPTPID FROM ZMD_SYS_DEPT ZSD CONNECT BY PRIOR ZSD.DEPTPID = ZSD.DEPTID START WITH ZSD.DEPTCODE='FACTORY'