為什么查詢會產生一個右括號：錯誤報告 - ORA-00907：缺少右括號 00907. 00000 - “缺少右括號” 我已經嘗試了所有關于放置右括號的地方，但它不起作用。
這是我的代碼：
CREATE TABLE Trips
(
Trips_ID NUMBER NOT NULL,
Date_of_Trip DATE NOT NULL,
Payment NUMBER NOT NULL,
Destination_Town VARCHAR2(50) NOT NULL,
Source_Town VARCHAR2 (50) NOT NULL,
Customer_ID NUMBER NOT NULL
CONSTRAINT Trip_pk
PRIMARY KEY (Trips_ID),
CONSTRAINT Customer_fk
FOREIGN KEY (Customer_ID) REFERENCES Customer (Customer_ID),
CONSTRAINT Owner_fk
FOREIGN KEY (Owner_ID) REFERENCES Vehicle_Owners (Owner_ID),
CONSTRAINT Payment_fk
FOREIGN KEY (Payment_ID) REFERENCES Payment (Payment_ID)
);
uj5u.com熱心網友回復：
在“Customer_ID NUMBER NOT NULL”之后添加一個逗號。那應該可以解決問題。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/376678.html
標籤：sql 甲骨文 oracle-sqldeveloper