关于ORA-00933错误的帮助

Question

如果我将以下语句作为sql脚本的一部分运行

-- create the pivot_sales_data table
CREATE TABLE pivot_sales_data AS
  SELECT *
  FROM (
   SELECT month, prd_type_id, amount
   FROM all_sales
   WHERE year = 2003
   AND prd_type_id IN (1, 2, 3)
  )
  PIVOT (
   SUM(amount) FOR month IN (1 AS JAN, 2 AS FEB, 3 AS MAR, 4 AS APR)
  )
  ORDER BY prd_type_id;

我得到ORA-00933: SQL命令没有正确结束的错误。这里我漏掉了什么？

Answer 1

你的轴心并不是真的有效。我特别考虑的是：

FOR month IN (1 AS JAN, 2 AS FEB, 3 AS MAR, 4 AS APR)

In实际上不是这样工作的。您可以选择：

FOR month IN ('JAN', 'FEB', 'MAR', 'APR')
-- or
FOR month IN (1,2,3,4)