Oracle：Pivot 转多列并包含多个名称

1SELECT *
2FROM
3  (SELECT l.DISTRIBUTOR_ID,
4    d.SKU_CODE,
5    d.WH_CODE,
6    d.ORDER_PACKAGES,
7    d.PRICE,
8    d.YEARLY||d.MONTHLY as YM
9    ,d.ORDER_PACKAGES * d.PRICE as TN
10  FROM SIMS_CVO_ORDER_PLAN_LIST l
11  INNER JOIN SIMS_CVO_ORDER_PLAN_DETAIL d
12  ON l.seq_id                                 =d.OWNER_SEQ_ID
13  WHERE l.SEQ_ID                              =85
14  ) pivot (max(ORDER_PACKAGES),max(TN) tn FOR YM IN ('201911','201912'));

注意：Pivot 多名称必须重命名，如上红色标识。

结果：