Oracle wm_concat在12c版本中的替代方法
select contractdetailid ,listagg(valuename,',')within group (order by valuename) as resonfrom approvedetail a left join (select * from dictionary where type ='SAPApproveCode' and languagecode= 'cn')...
原创
2019-06-18 14:50:30 ·
3572 阅读 ·
0 评论