select listagg(serial_number, ‘’’,’’’) within group (order by serial_number) ||’’’’ from table where rownum<5;
oracle利用listagg把多列合成一行并用指定分隔符分割
最新推荐文章于 2024-07-18 16:37:11 发布
select listagg(serial_number, ‘’’,’’’) within group (order by serial_number) ||’’’’ from table where rownum<5;