SQL建表报错：NARRATIVE字段相关语法错误排查求助

• 错误根源：列名CONSUMER COMPLAINT NARRATIVE包含空格，SQL解析器会将空格分隔的内容视为独立的语法单元，因此在解析到NARRATIVE时无法识别，触发语法错误。其他带空格的列名（如Company Public Response、State Name等）也会引发同类问题。

• 解决方法：将所有带空格的列名用双引号包裹，明确其为完整的标识符。修正后的语句如下：

CREATE TABLE CONSUMER_COMPLAINTS 
(    
    DATE_RECEIVED STRING,
    PRODUCT_NAME VARCHAR2(50), 
    SUB_PRODUCT VARCHAR2(40), 
    ISSUE VARCHAR2(100), 
    SUB_ISSUE VARCHAR2(100),
    "CONSUMER COMPLAINT NARRATIVE" VARCHAR2(100),
    "Company Public Response" STRING,
    Company VARCHAR(30),
    "State Name" CHAR(4),
    Zip_Code INTEGER,
    Tags VARCHAR(10),
    "Consumer Consent Provided" CHAR(6),
    "Submitted via" STRING,
    "Date Sent_to_Company" STRING,
    "Company Response_to_Consumer" VARCHAR(2),
    "Timely Response" CHAR(4),
    "CONSUMER DISPUTED" CHAR(4),
    COMPLAINT_ID NUMBER(12,0) NOT NULL PRIMARY KEY
);

内容的提问来源于stack exchange，提问作者chaman kumar