oralce中如何将多列合成一行,并用分隔符来分割,以下是SQL:
select listagg(serial_number, ‘’’,’’’) within group (order by serial_number) ||’’’’ from table where rownum<5;
oralce中如何将多列合成一行,并用分隔符来分割
最新推荐文章于 2023-01-30 18:04:19 发布
oralce中如何将多列合成一行,并用分隔符来分割,以下是SQL:
select listagg(serial_number, ‘’’,’’’) within group (order by serial_number) ||’’’’ from table where rownum<5;