CREATE TABLE WEB_CULTURE(
CULTURE_ID NUMBER(10),
CULTURE_TITLE VARCHAR2(500),
CULTURE_TYPE NUMBER(10),
CULTURE_DATE DATE(7),
DEPT VARCHAR2(100),
CULTURE_CONTENT BLOB,
CULIMG_URL VARCHAR2(256),
CUL_TITLE VARCHAR2(128),
CONSTRAINT WEB_CULTURE PRIMARY KEY (CULTURE_ID)
);
这段建表语句报 ORA-00907:缺失右括号
CULTURE_ID NUMBER(10),
CULTURE_TITLE VARCHAR2(500),
CULTURE_TYPE NUMBER(10),
CULTURE_DATE DATE(7),
DEPT VARCHAR2(100),
CULTURE_CONTENT BLOB,
CULIMG_URL VARCHAR2(256),
CUL_TITLE VARCHAR2(128),
CONSTRAINT WEB_CULTURE PRIMARY KEY (CULTURE_ID)
);
这段建表语句报 ORA-00907:缺失右括号
,
CONSTRAINT WEB_CULTURE PRIMARY KEY (CULTURE_ID)
先去掉,还有你要注意中文的括号与英文的括号。
CULTURE_DATE DATE
);
CULTURE_DATE DATE
);
没错,我就是这个意思,如下就可以建表了,我试过了CREATE TABLE WEB_CULTURE(
CULTURE_ID NUMBER(10),
CULTURE_TITLE VARCHAR2(500),
CULTURE_TYPE NUMBER(10),
CULTURE_DATE DATE,
DEPT VARCHAR2(100),
CULTURE_CONTENT BLOB,
CULIMG_URL VARCHAR2(256),
CUL_TITLE VARCHAR2(128),
CONSTRAINT WEB_CULTURE PRIMARY KEY (CULTURE_ID)
);
CULTURE_DATE DATE
);
没错,我就是这个意思,如下就可以建表了,我试过了CREATE TABLE WEB_CULTURE(
CULTURE_ID NUMBER(10),
CULTURE_TITLE VARCHAR2(500),
CULTURE_TYPE NUMBER(10),
CULTURE_DATE DATE,
DEPT VARCHAR2(100),
CULTURE_CONTENT BLOB,
CULIMG_URL VARCHAR2(256),
CUL_TITLE VARCHAR2(128),
CONSTRAINT WEB_CULTURE PRIMARY KEY (CULTURE_ID)
);学习、了