兄弟们救命!! DEFAULT '黑龙江' NOT NULL,所有这些都要加单引号 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 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" 这个是怎么回事呀谢谢! 同意 beckhambobo(beckham) 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" 显示为非法的零长度标识 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" ; to_date('2001-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss') 汉字用 ' ' (单引号括起来)日期用 To_date() 来规范化 我贴的SQL已经可以创建。日期如果用字符串拼成oracle日期格式,则需单引号为:'16-10月-2003'如果用函数则不用单引号为:to_date('2003-10-16','yyyy-mm-dd') 如何提高此sql執行效率 Oracle数据库推荐使用什么字符集?我的Linux系统中的字符集是zh_CN.UTF-8 求一sql语句: 跪求一統計語句 Oracle 可以有两个SID同时运行吗? oracle9i 在windows 上面有没有2G或者几G (大文件)的问题 sql语句的解释 ORA-04091 如何解决,在线等~~~ 关于在VISIO中绘制数据库模型图的几点疑问? 如何在Linux8.0下安裝oracle9 使用Oracle Enterprise Server备份数据库的问题 连接 数据库 问题!
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"
这个是怎么回事呀谢谢!
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"
显示为非法的零长度标识
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" ;
日期如果用字符串拼成oracle日期格式,则需单引号为:'16-10月-2003'
如果用函数则不用单引号为:to_date('2003-10-16','yyyy-mm-dd')