如何在Oracle服务器中将多行文本合并为单个文本字符串? [英] How to concatenate text from multiple rows into a single text string in Oracle server?
本文介绍了如何在Oracle服务器中将多行文本合并为单个文本字符串?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一张表,上面有这样的数据:
I have a table with data like this:
ID, END_DATE, CLOSE_DATE
1, 2018-05-18, 2018-05-15
2, 2018-05-18, 2018-05-14
3, 2018-05-18, 2018-05-11
4, 2018-05-18, 2018-05-10
我在Oracle服务器中查询时需要输出
I need the output when i query in Oracle server
END_DATE CLOSE_DATE ID
2018-05-18 [2018-05-15,2018-05-14,2018-05-11,2018-05-10] [1,2,3,4]
我尝试使用listagg,但它适用于ID或关闭日期,但不能同时使用两者.
I have tried to use listagg, but its working either for Id or Close Date but not both.
select (listagg(CLOSE_DATE,',') within group (order by CLOSE_DATE DESC)) CLOSE_DATE
, END_DATE
from TBL_S_PLCLOSEDATE
where D_END='18-MAY-2018'
请让我知道如何在Oracle服务器中编写相同的sql.
Please let me know how to write the sql for the same in Oracle server.
推荐答案
您尝试过吗?
select end_date,
listagg(CLOSE_DATE, ',') within group (order by CLOSE_DATE DESC) as close_dates,
listagg(id, ',') within group (order by id) as ids
from TBL_S_PLCLOSEDATE
where D_END = date '2018-05-18'
group by end_date;
这篇关于如何在Oracle服务器中将多行文本合并为单个文本字符串?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文