2022-02-03 174 0

listagg函数的用法这是一个Oracle的列转行函数：LISTAGG() 先看示例代码：Sql代码 1234567891011with temp as( select 'China' nation ,'Guangzhou' city from dual union all select 'China' nation ,'Shanghai' city from dual union all select 'China' nation ,'Beijing' city from dual