oracle行转列

SELECT VIN,
MAX(decode(PARAM_CODE, 'CT_BSQDWS', PARAM_VALUE,null)) AS CT_BSQDWS,
MAX(decode(PARAM_CODE, 'CT_BSQXS', PARAM_VALUE,null)) AS CT_BSQXS,
MAX(decode(PARAM_CODE, 'CT_EDGL', PARAM_VALUE,null)) AS CT_EDGL,
MAX(decode(PARAM_CODE, 'CT_FDJXH', PARAM_VALUE,null)) AS CT_FDJXH,
MAX(decode(PARAM_CODE, 'CT_JGL', PARAM_VALUE,null)) AS CT_JGL,
MAX(decode(PARAM_CODE, 'CT_PL', PARAM_VALUE,null)) AS CT_PL,
MAX(decode(PARAM_CODE, 'CT_QGS', PARAM_VALUE,null)) AS CT_QGS,
MAX(decode(PARAM_CODE, 'CT_QTXX', PARAM_VALUE,null)) AS CT_QTXX,
MAX(decode(PARAM_CODE, 'CT_SJGKRLXHL', PARAM_VALUE,null)) AS CT_SJGKRLXHL,
MAX(decode(PARAM_CODE, 'CT_SQGKRLXHL', PARAM_VALUE,null)) AS CT_SQGKRLXHL,
MAX(decode(PARAM_CODE, 'CT_ZHGKCO2PFL', PARAM_VALUE,null)) AS CT_ZHGKCO2PFL,
MAX(decode(PARAM_CODE, 'CT_ZHGKRLXHL', PARAM_VALUE,null)) AS CT_ZHGKRLXHL


FROM RLLX_PARAM_ENTITY   
GROUP BY VIN