错误:ORA-00907:缺少右括号 [英] Error : ORA-00907: missing right parenthesis

问题描述

我正在尝试创建一个简单的表，但这给了我一个错误提示:

I'm trying to create a simple table but it's giving me an error says:

Error starting at line : 1 in command -
CREATE TABLE dj_abonent
(
nr_klienti int NOT NULL,
emer_klienti varchar2(10),
sasia_cel int
CONSTRAINT dj_klientID PRIMARY KEY(nr_klienti)
)
Error at Command Line : 6 Column : 35
Error report -
SQL Error: ORA-00907: missing right parenthesis
00907. 00000 -  "missing right parenthesis"
*Cause:    
*Action:
Error starting at line : 1 in command -
CREATE TABLE dj_abonent
(
nr_klienti int NOT NULL,
emer_klienti varchar2(10),
sasia_cel int,
CONSTRAINT dj_klientID PRIMARY KEY(nr_klienti)
)
Error at Command Line : 1 Column : 14
Error report -
SQL Error: ORA-00955: name is already used by an existing object
00955. 00000 -  "name is already used by an existing object"
*Cause:    
*Action:

推荐答案

您遇到第二个错误，因为您将dj_klientID用作两个约束的名称.它们必须是唯一的.

Your have the second error because you use dj_klientID as name for both of the constraints. They have to be unique.

尝试重命名两个约束之一，第二个查询也将得到解决.

Try renaming one of the two constraints and also your second query will be fixed.

这篇关于错误:ORA-00907:缺少右括号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！