Oracle 11g: ORA-00907: missing right parenthesis solution

最新推荐文章于 2022-09-28 14:33:02 发布

最新推荐文章于 2022-09-28 14:33:02 发布 · 109 阅读

文章标签：

#数据库

本文讨论了在使用SQL创建表时遇到的常见错误：ORA-00907：缺少右括号。通过分析示例代码，解释了错误原因，并提供了修正方法。重点在于检查SQL语句中是否存在拼写错误，特别是对于关键字的正确拼写。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Issue:

When you create table using sql like this.

SQL> create table ships
  2  (
  3    ship_id number ,
  4    ship_name varchar2(20),
  5    home_PORT_ID number,
  6    constrain ships_ports_fk foreign key (home_port_id) references ports (po
t_id)
  7  );

You may got following error message after execute.

constrain ships_ports_fk foreign key (home_port_id) references ports (port_id)

*
第 6 行出现错误:
ORA-00907: missing right parenthesis solution

Reason:

You may have something misspell.

Solution:

Please review your sql code to check if anything is misspelled. E.g. In my case, I misspell "constraint" as "constrain".