学习无止境！

摘要： Sql的CTEWITH EMPLOYEE_LIST AS (SELECT A.EMP_NO AS APPROVER_ID,1 AS SEQUENCE_NO,'实际需求方/DEPT MANAGER' AS APPROVER_ROLE,A.SUPERVISORFROM AM_EMPLOYEE A,FIN_APPROVE_MODEL BWHERE B.FORM_TYPE='CT_BI' AND B.OU_CODE=@OU_CODEAND A.EMP_NO= B.EMPLOYEE_NUMBER AND A.EMP_NO=@EMP_NOUNION ALLSELECT A.EMP_NO AS APPROV 阅读全文

摘要： SELECT ename FROM scott.emp START WITH ename = 'KING' CONNECT BY PRIOR empno = mgr; --得到结果为： KING JONES SCOTT ADAMS FORD SMITH BLAKE ALLEN WARD MARTIN TURNER JAMES 而： SELECT SYS_CONNECT_BY_PATH(ename, '') "Path" FROM scott.emp START WITH ename = 'KING' CONNECT BY PRIOR empno = mgr; --得到结果为： KING 阅读全文

摘要： 阿里巴巴项目用到：SELECT LTRIM(MAX(SYS_CONNECT_BY_PATH(ou_code, ';')), ';') AS RESULT FROM (SELECT category_id, ou_code, RN, LEAD(RN) OVER(ORDER BY RN) RN1 FROM (SELECT category_id, ou_code, ROW_NUMBER() OVER(ORDER BY category_id, ou_code DESC) RN FROM (SELECT t.category_id, t.ou_code FROM bpm_dcs_category_o 阅读全文