Oracle 行转列 行合并

select supplier,productno,classname, LISTAGG( lll, ',' ) within group ( order by className ) as name,
LISTAGG( llk, ',' ) within group ( order by className ) as llk from 
(
    SELECT * FROM ecy_meter_result
    PIVOT 
    (
        max(value||' '||isok) FOR 
        point IN ('直径' as lll,'半径' as llk)
    )
)GROUP BY supplier,productno,classname;

 

 

 

update asinsupply o
join amazon_merchantlisting u
on o.ASIN = u.asin1
set o.shop = u.companyid;