oracle行列转换的方法是什么

SELECT *
FROM (
    SELECT product_type, sales_amount
    FROM sales_data
)
PIVOT 
(
    SUM(sales_amount)
    FOR product_type IN ('A' AS A_sales, 'B' AS B_sales, 'C' AS C_sales)
);

SELECT product_type, sales_amount
FROM (
    SELECT A_sales, B_sales, C_sales
    FROM sales_data
)
UNPIVOT 
(
    sales_amount FOR product_type IN (A_sales AS 'A', B_sales AS 'B', C_sales AS 'C')
);