oracle sql查询结果某字段 行转列，逗号分隔

LISTAGG(BS,',') WITHIN GROUP(ORDER BY ENGINE_NO)

query.append("SELECT LICENSE_PLATE,SVIN,MAINTENANCE_DATE,DEFAULT_VIN,ENGINE_NO, \n");
                query.append("       case when LISTAGG(BS,',') WITHIN GROUP(ORDER BY ENGINE_NO) = 'DRIVER,OWNER' then 'OWNER' \n");
                query.append("       when LISTAGG(BS,',') WITHIN GROUP(ORDER BY ENGINE_NO) = 'OWNER' then 'OWNER' \n");
                query.append("       when LISTAGG(BS,',') WITHIN GROUP(ORDER BY ENGINE_NO) = 'DRIVER'then 'DRIVER' \n");
                query.append("       END BS  \n");
                query.append("FROM (  \n");
                query.append("      SELECT DISTINCT * FROM (SELECT MV.LICENSE_PLATE,MV.SVIN, \n");
                query.append("             TO_CHAR(MV.MAINTENANCE_DATE,'yyyy-MM-dd') MAINTENANCE_DATE,MVM.DEFAULT_VIN, \n");
                query.append("             MV.ENGINE_NO,'OWNER' BS \n");//OWNER 车主
                query.append("             FROM CMS.MAIN_VEHICLE_MENBER MVM,MAIN_VEHICLE MV \n");
                query.append("             WHERE MVM.OWNER_ID = MV.OWNER_ID \n");
                query.append("             AND MVM.MOBILE = '"+telephone+"' \n");
                query.append("      UNION \n");
                query.append("      SELECT MV.LICENSE_PLATE,MV.SVIN,TO_CHAR(MV.MAINTENANCE_DATE,'yyyy-MM-dd') MAINTENANCE_DATE, \n");//DRIVER 司机
                query.append("             DV.DEFAULT_VIN,MV.ENGINE_NO, 'DRIVER' BS FROM ( \n");
                query.append("             SELECT MVM.OWNER_ID,MVM.DEFAULT_VIN,MODR.VIN FROM CMS.MAIN_VEHICLE_MENBER MVM,CMS.MAIN_VEHICLE_DRIVER_RELATION MODR \n");
                query.append("             WHERE MVM.OWNER_ID = MODR.DRIVER_ID \n");
                query.append("             AND MVM.MOBILE = '"+telephone+"' \n");
                query.append("      ) DV, MAIN_VEHICLE MV \n");
                query.append("      WHERE DV.VIN = MV.SVIN) \n");
                query.append(" ) GROUP BY LICENSE_PLATE,SVIN,MAINTENANCE_DATE,DEFAULT_VIN,ENGINE_NO \n");