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