如何把多行变成一行显示,以LOT_RRN为主键
用这个函数listagg
参考
https://www.jb51.net/database/3234541f4.htm
=====================
数据量不大的话 ,也可以用vm_concat函数
https://blog.csdn.net/baoyuhang0/article/details/110160431
SELECT l.LOT_RRN, LISTAGG(supplier_id, ',') WITHIN GROUP (ORDER BY l.LOT_RRN) AS supplier_id_str FROM your_table GROUP BY l.LOT_RRN
用wm_concat(字段)