兄弟们救命！！

[lclmdj]

我用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 [e-mail] 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)

[beckhambobo]

DEFAULT '黑龙江' NOT NULL,所有这些都要加单引号

[lclmdj]

在哪个位置加呀！

[podded]

默认为字符型的都要将默认值加单引号，数值型和函数型的不用加。

[lclmdj]

CREATE TABLE "SYSTEM"."MOVIE_CENTER"("MOVIE_ID" NUMBER(10)
DEFAULT 1 NOT NULL, "MOVIE_NAME" VARCHAR2(64) DEFAULT '无间道II'
NOT NULL, "MOVIE_TYPE" VARCHAR2(64) DEFAULT '恐怖片' NOT NULL,
"MOVIE_GADEN" VARCHAR2(64) DEFAULT '普通电影' NOT NULL,
"TUIJIAN_GADEN" VARCHAR2(64) DEFAULT 'A' NOT NULL, "ACTOR"
VARCHAR2(64) DEFAULT '刘德华 曾志伟' NOT NULL, "COUNTRY" VARCHAR2(
64) DEFAULT '香港' NOT NULL, "UPLOAD_DATE" DATE DEFAULT 2003-10-16
NOT NULL, "MOVIE_MINUTE" VARCHAR2(10) DEFAULT '120' NOT NULL,
"MOVIE_DEMO" VARCHAR2(256) DEFAULT '电影简介' NOT NULL, "DOWN_COUNT"
NUMBER(10) DEFAULT 1 NOT NULL, "TYPE" VARCHAR2(2) DEFAULT '1'
NOT NULL,
CONSTRAINT "" PRIMARY KEY("MOVIE_ID"))
TABLESPACE "USERS"
这个是怎么回事呀谢谢!

[verybigmouthz]

同意 beckhambobo(beckham)

[lclmdj]

CREATE TABLE "SYSTEM"."MOVIE_CENTER"("MOVIE_ID" NUMBER(10)
DEFAULT 1 NOT NULL, "MOVIE_NAME" VARCHAR2(64) DEFAULT '无间道II'
NOT NULL, "MOVIE_TYPE" VARCHAR2(64) DEFAULT '恐怖片' NOT NULL,
"MOVIE_GADEN" VARCHAR2(64) DEFAULT '普通电影' NOT NULL,
"TUIJIAN_GADEN" VARCHAR2(64) DEFAULT 'A' NOT NULL, "ACTOR"
VARCHAR2(64) DEFAULT '刘德华 曾志伟' NOT NULL, "COUNTRY" VARCHAR2(
64) DEFAULT '香港' NOT NULL, "UPLOAD_DATE" DATE DEFAULT 2003-10-16
NOT NULL, "MOVIE_MINUTE" VARCHAR2(10) DEFAULT '120' NOT NULL,
"MOVIE_DEMO" VARCHAR2(256) DEFAULT '电影简介' NOT NULL, "DOWN_COUNT"
NUMBER(10) DEFAULT 1 NOT NULL, "TYPE" VARCHAR2(2) DEFAULT '1'
NOT NULL,
CONSTRAINT "" PRIMARY KEY("MOVIE_ID"))
TABLESPACE "USERS"
显示为非法的零长度标识

[podded]

1、CONSTRAINT "" PRIMARY KEY("MOVIE_ID")) 的CONSTRAINT后写个名字吧，或者中间来个空格
2、2003-10-16 日期格式也不对

如下：
CREATE TABLE "SYSTEM"."MOVIE_CENTER"("MOVIE_ID" NUMBER(10)
DEFAULT 1 NOT NULL, "MOVIE_NAME" VARCHAR2(64) DEFAULT '无间道II'
NOT NULL, "MOVIE_TYPE" VARCHAR2(64) DEFAULT '恐怖片' NOT NULL,
"MOVIE_GADEN" VARCHAR2(64) DEFAULT '普通电影' NOT NULL,
"TUIJIAN_GADEN" VARCHAR2(64) DEFAULT 'A' NOT NULL, "ACTOR"
VARCHAR2(64) DEFAULT '刘德华 曾志伟' NOT NULL, "COUNTRY" VARCHAR2(
64) DEFAULT '香港' NOT NULL, "UPLOAD_DATE" DATE DEFAULT '16-10月-2003'
NOT NULL, "MOVIE_MINUTE" VARCHAR2(10) DEFAULT '120' NOT NULL,
"MOVIE_DEMO" VARCHAR2(256) DEFAULT '电影简介' NOT NULL, "DOWN_COUNT"
NUMBER(10) DEFAULT 1 NOT NULL, "TYPE" VARCHAR2(2) DEFAULT '1'
NOT NULL,
CONSTRAINT PK_MOVIE_CENTER PRIMARY KEY("MOVIE_ID"))
TABLESPACE "USERS" ;

[lclmdj]

oracle日期格式怎么写呀

[cmaboy]

to_date('2001-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss')

[chanet]

汉字用 ' ' (单引号括起来)

日期用 To_date() 来规范化

[podded]

我贴的SQL已经可以创建。
日期如果用字符串拼成oracle日期格式，则需单引号为：'16-10月-2003'
如果用函数则不用单引号为：to_date('2003-10-16','yyyy-mm-dd')