oracle报错00905,ORACLE 建表出现‘ORA-00905: missing keyword’的异常

ORACLE 建表出现‘ORA-00905: missing keyword’的错误

点击右边红色标题查看本文完整版：ORACLE 建表出现‘ORA-00905: missing keyword’的错误

在ORACLE 10G上面建一个表，总是出现‘ORA-00905: missing keyword’的错误，具体sql语句如下，请高手指点一下：

================================================================================================

CREATE TABLE MGPCONDELE (MGPCONDELE_ID NUMBER(19) NOT NULL, MBRGRP_ID NUMBER(19) NOT NULL, NAME VARCHAR2(64) NOT NULL, TYPE VARCHAR2(64) NOT NULL, PARENT VARCHAR2(64), SEQUENCE DOUBLE, OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 , NEGATE SMALLINT NOT NULL DEFAULT 0, VARIABLE VARCHAR2(254), OPERATOR VARCHAR2(16), VALUE VARCHAR2(254), CONDNAME VARCHAR2(254), CONSTRAINT MBRGRPELE_PK PRIMARY KEY(MGPCONDELE_ID), CONSTRAINT MBRGRPELE_FK FOREIGN KEY (MBRGRP_ID) REFERENCES MBRGRP(MBRGRP_ID) ON DELETE CASCADE);

================================================================================================

这个语句是从DB2上面改过来的，就改了一些数据类型的定义，别的没动。

------解决方法--------------------

改成这样

CREATE TABLE MGPCONDELE (

MGPCONDELE_ID NUMBER(19) NOT NULL,

MBRGRP_ID NUMBER(19) NOT NULL,

NAME VARCHAR2(64) NOT NULL,

TYPE VARCHAR2(64) NOT NULL,

PARENT VARCHAR2(64),

SEQUENCE float, -- 没有double,有float

OPTCOUNTER smallINT  DEFAULT 0 NOT NULL, -- NOT NULL 和 DEFAULT顺序要调整过来

NEGATE SMALLINT DEFAULT 0 NOT NULL ,

VARIABLE VARCHAR2(254),

OPERATOR VARCHAR2(16),

VALUE VARCHAR2(254),

CONDNAME VARCHAR2(254),

CONSTRAINT MBRGRPELE_PK PRIMARY KEY(MGPCONDELE_ID)

CONSTRAINT MBRGRPELE_FK FOREIGN KEY (MBRGRP_ID)

REFERENCES MBRGRP(MBRGRP_ID)

ON DELETE CASCADE

);