oracle 所有下级

--所有下级

SELECT SAP_ORGAN_CODE FROM SAP_ORGAN_LEVEL CONNECT BY PRIOR SAP_FATHER_ORGAN_CODE= SAP_ORGAN_CODE START WITH SAP_FATHER_ORGAN_CODE='SU01';

 

转载于:https://www.cnblogs.com/hupolinglong/p/5644309.html