如何在oracle中使pivot具有默认值？

SELECT *
FROM (
  SELECT column1, column2
  FROM your_table
)
PIVOT (
  COUNT(column2)
  FOR column1 IN ('Value1' AS value1, 'Value2' AS value2, 'Value3' AS value3)
)
UNION ALL
SELECT 'Default' AS column1, COALESCE(value1, 0) AS value1, COALESCE(value2, 0) AS value2, COALESCE(value3, 0) AS value3
FROM (
  SELECT column1, column2
  FROM your_table
)
PIVOT (
  COUNT(column2)
  FOR column1 IN ('Value1' AS value1, 'Value2' AS value2, 'Value3' AS value3)
)
WHERE value1 IS NULL AND value2 IS NULL AND value3 IS NULL;