Oracle的MAP和PIVOT函數都是用于處理數據的高級功能，但它們之間存在一些關鍵區別
示例：
SELECT product_id,
MAP(product_category, 'Electronics', 1, 'Clothing', 2, 'Books', 3) AS category_id
FROM products;
示例：
SELECT *
FROM (SELECT order_id, product_id, quantity FROM order_details)
PIVOT (
SUM(quantity)
FOR product_id IN ('P1' AS product_1, 'P2' AS product_2, 'P3' AS product_3)
);
總結：
