单独一行一行执行不会报错,一起执行就会报错,为什么
create table DIM_FOMATS
(
FOMATS_ID CHAR(8) not null,
FOMATS VARCHAR2(100),
START_DATE CHAR(8),
END_DATE CHAR(8),
START_FLAG CHAR(2),
constraint PK_DIM_FOMATS primary key (FOMATS_ID)
);
comment on table DIM_FOMATS is
'业态(产业/集中商业/社区商铺/写字楼/酒店/教育/医疗/经营配套)';
'业态(产业/集中商业/社区商铺/写字楼/酒店/教育/医疗/经营配套)';
comment on column DIM_FOMATS.FOMATS_ID is
'业态ID';
'业态ID';
comment on column DIM_FOMATS.FOMATS is '业态';
comment on column DIM_FOMATS.START_DATE is
'生效日期';
'生效日期';
comment on column DIM_FOMATS.END_DATE is
'失效日期';
'失效日期';
comment on column DIM_FOMATS.START_FLAG is
'启动标识';
'启动标识';