举例
SELECT ORGAN_ID FROM T_COMPANY_ORGAN CO START WITH CO.ORGAN_ID = '4000000' CONNECT BY PARENT_ID = PRIOR CO.ORGAN_ID;
举例
SELECT ORGAN_ID FROM T_COMPANY_ORGAN CO START WITH CO.ORGAN_ID = '4000000' CONNECT BY PARENT_ID = PRIOR CO.ORGAN_ID;
转载于:https://www.cnblogs.com/zengpingtang/p/11118804.html