美文网首页
2019-05-23

2019-05-23

作者: emei18 | 来源:发表于2019-05-23 09:32 被阅读0次

oracle多行合并一行

select username, id, LISTAGG(subject, '-') within group(order by subject) as subject, LISTAGG(score, ',') within group(order by score) as score from STUDENTSCORES group by username, id

-- Create the synonym
create or replace synonym xx_OTM_ORD_TRANSIT_DETAIL
for xxx.xx_OTM_ORD_TRANSIT_DETAIL@xxxx;

相关文章

网友评论

      本文标题:2019-05-23

      本文链接:https://www.haomeiwen.com/subject/rbgmzqtx.html