[20230508]ORA-00907 missing right parenthesis.txt

[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.