with t as (
Select ‘2021-01’ MONTH, ‘苹果’ name, 300 nums from dual
Union
Select ‘2021-02’ MONTH, ‘苹果’ name, 200 nums from dual
Union
Select ‘2021-03’ MONTH, ‘苹果’ name, 100 nums from dual
Union
Select ‘2021-01’ MONTH, ‘桃子’ name, 111 nums from dual
Union
Select ‘2021-02’ MONTH, ‘桃子’ name, 222 nums from dual
Union
Select ‘2021-03’ MONTH, ‘桃子’ name, 333 nums from dual
)
select * from t pivot(sum(nums) for MONTH in (‘2021-01’,‘2021-02’,‘2021-03’))