ORA-00984: 列在此處不允許 SQL parse error location

來源:互聯網
上載者:User

ORA-00984: 列在此處不允許 SQL parse error location

ORA-00984: 列在此處不允許
SQL parse error location

Oracle 插入資料的時候一直提示列在此處不允許。網上搜尋答案說是類型不符的多,但我的錯誤確是一個低級錯誤,插入的時候資料使用了雙引號。謹記之……

錯誤:

INSERT INTO ZP_CDC.T_WEBCHAT_QUOTATION (ID, QUOTATION_ID)
VALUES (SEQ_T_WEBCHAT_QUOTATION.nextval, " aaa");

正確:

INSERT INTO ZP_CDC.T_WEBCHAT_QUOTATION (ID, QUOTATION_ID)
VALUES (SEQ_T_WEBCHAT_QUOTATION.nextval,'aaa');

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.