创建oracle数据库的表时,提示"列在此处不允许",怎么办?
创建oracle数据库的表时,提示"列在此处不允许",怎么办?代码如下:
CREATE TABLE "SCOTT"."FRIENDS_INFORMATION" ("NUM" NUMBER(4) NOT
NULL, "NAME" CHAR(8) NOT NULL, "AGE" NUMBER(3) NOT NULL,
"ADDRESS" VARCHAR2(20) NOT NULL, "SEX" CHAR(2) DEFAULT male
NOT NULL, "PHONENUM" NUMBER(11) NOT NULL, "FAMILYTELNUM"
NUMBER(11) NOT NULL, "E-MAIL" VARCHAR2(25) NOT NULL, "MSN"
VARCHAR2(25) NOT NULL, "QQ" NUMBER(12) NOT NULL, "WORK"
VARCHAR2(10) NOT NULL,
CONSTRAINT "NUM" PRIMARY KEY("NUM"),
CONSTRAINT "NUM" UNIQUE("NUM"),
CONSTRAINT "NUM" CHECK(num BETWEEN 0001
AND 9999))
TABLESPACE "PCDB" PCTFREE 20 PCTUSED 60 INITRANS 2
STORAGE ( INITIAL 147456 NEXT 8192 PCTINCREASE 0)
在点击完成时,提示“列在此处不允许”,在控制台或者是在导航器上创建都是这样提示的上网搜出错原因时又搜不到原因,根本就没办法创建表。