SELECT NVL(B.USER_NAME, C.USER_NAME) AS LINGDAO FROM SYS_USER_EXT A, HR_USERS B, HR_USERS C WHERE A.DEPT_CODE = B.DEPT_ID(+) AND B.ADMIN_JOB(+) = 10 AND A.DEPT_CODE = C.DEPT_ID(+) AND C.ADMIN_JOB(+) = 11
17,377
社区成员
95,128
社区内容
加载中
试试用AI创作助手写篇文章吧