UC知道oracle 缺失左括号
来源：百度知道 编辑：UC知道 时间：2024/07/04 09:07:57
SQL> CREATE TABLE CUSTOMERS
2 (CUST_NUM INTEGER NOT NULL,
3 COMPANY VARCHAR(20) NOT NULL,
4 CUST_REP INTEGER,
5 CREDIT_LIMIT MONEY,
6 PRIMARY KEY (CUST_NUM),
7 FOREIGN KEY HASREP (CUST_REP)
8 REFERENCES SALESREPS
9 ON DELETE SET NULL);
FOREIGN KEY HASREP (CUST_REP)
*
第 7 行出现错误:
ORA-00906: 缺失左括号
内容如上,还有7 8行为什么不用加逗号
以上语句是从SQL书上抄来的
2 (CUST_NUM INTEGER NOT NULL,
3 COMPANY VARCHAR(20) NOT NULL,
4 CUST_REP INTEGER,
5 CREDIT_LIMIT MONEY,
6 PRIMARY KEY (CUST_NUM),
7 FOREIGN KEY HASREP (CUST_REP)
8 REFERENCES SALESREPS
9 ON DELETE SET NULL);
FOREIGN KEY HASREP (CUST_REP)
*
第 7 行出现错误:
ORA-00906: 缺失左括号
内容如上,还有7 8行为什么不用加逗号
以上语句是从SQL书上抄来的
CREATE TABLE CUSTOMERS
(CUST_NUM INTEGER NOT NULL,
COMPANY VARCHAR(20) NOT NULL,
CUST_REP INTEGER,
CREDIT_LIMIT MONEY,
CONSTRAINT PK_CUSTOMERS PRIMARY KEY (CUST_NUM),
constraint FK_CUSTOMERS foreign key (CUST_REP)
references SALESREPS(CUST_REP)
ON DELETE SET NULL);