[20230508]ORA-00907 missing right parenthesis.txt

--//链接 logic.edchen.org/how-to-resolve-ora-00907-missing-right-parenthesis/,重复测试:

1.环境:
SCOTT@book> @ver1
PORT_STRING                    VERSION        BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

2.测试:

SCOTT@book> create table fruits (fruit_name varchar2(20), price number not null default 20);
create table fruits (fruit_name varchar2(20), price number not null default 20)
                                                                    *
ERROR at line 1:
ORA-00907: missing right parenthesis

--//不能不讲,给出的错误提示非常让人迷惑,作者给出的解析:

Please note that, the right parenthesis is also known as right round bracket. In CREATE TABLE statement, what
parenthesis encloses is the column list.

In this case, DEFAULT is a valid reserved keyword, but it should be appeared before NOT NULL, not after. So we should
rearrange the order of clauses in the statement to correct the problem.

--//修改为default在前面:

SCOTT@book> create table fruits (fruit_name varchar2(20), price number default 20 not null);
Table created.

--//SCOTT@book> drop table fruits purge;
--//Table dropped.