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;