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_

转载于:https://www.cnblogs.com/mwd-banbo/p/10176040.html