Oracle "行转列"搭配"临时视图"

with T_EXPERT as (select E.EXPERT_ID_,E.COM_CODE_,E.COM_NAME_,E.EMP_NAME_,E.STATUS_,ER.PARENT_PRO_CODE_,ER.PRO_CODE_ from MP_EXPERT E inner join MP_EXPERT_RELATION ER on ER.EXPERT_ID_ = E.EXPERT_ID_ and ER.PARENT_PRO_CODE_ is not null
?)select T_EXPERT.EXPERT_ID_,COM_CODE_,COM_NAME_,EMP_NAME_,STATUS_,(select wm_concat(distinct PARENT_PRO_CODE_) from T_EXPERT T where T.EMP_NAME_ = T_EXPERT.EMP_NAME_) as PARENT_PRO_CODE_,(select wm_concat(PRO_CODE_) from T_EXPERT T where T.EMP_NAME_ = T_EXPERT.EMP_NAME_) as CHILD_PRO_CODE_ from T_EXPERT group by T_EXPERT.EXPERT_ID_,T_EXPERT.COM_CODE_,T_EXPERT.COM_NAME_,T_EXPERT.EMP_NAME_,T_EXPERT.STATUS_

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!