兄弟们救命!!
我用oracle dba studio建一个数据表结果出现
提示:ora_00984:列在此处不允许
sql语句如下:
CREATE TABLE "SYSTEM"."USER_CENTER"("USER_ID" NUMBER(10) NOT
NULL, "USER_NAME" VARCHAR2(64) DEFAULT admin NOT NULL,
"PASS_WORD" VARCHAR2(64) DEFAULT 12345678 NOT NULL, "PREVINCE"
VARCHAR2(64) DEFAULT 黑龙江 NOT NULL, "HOME_ADDRESS" VARCHAR2(128)
DEFAULT 海淀区小南庄28号501 NOT NULL, "SHOW_QUESTION" VARCHAR2(64)
DEFAULT 手机 NOT NULL, "ANSWER_QUESTION" VARCHAR2(64) DEFAULT 号码
NOT NULL, "SEX" VARCHAR2(10) DEFAULT 男 NOT NULL, "E-MAIL"
VARCHAR2(64) DEFAULT lclmdj@sina.com.cn NOT NULL, "TEL" VARCHAR2(
64) DEFAULT 13161831724 NOT NULL,
CONSTRAINT "" PRIMARY KEY("USER_ID"),
CONSTRAINT "USER_ID" UNIQUE("USER_ID"),
CONSTRAINT "USER_ID" CHECK(user_id between 1-999999))
TABLESPACE "USERS" PCTFREE 20 PCTUSED 60 INITRANS 2
STORAGE ( INITIAL 57344 NEXT 581632 PCTINCREASE 0)