随便给你个实施。 用sqlplus执行 prompt prompt Creating table BB_MX prompt ==================== prompt create table BB_MX ( ID NUMBER(8), BH NUMBER(10), MC VARCHAR2(100), NIAN NUMBER(4), YUE NUMBER(2), BZ NUMBER(2) ); comment on table BB_MX is '报表明细'; comment on column BB_MX.ID is '局号'; comment on column BB_MX.BH is '报表编号'; comment on column BB_MX.MC is '报表名称'; comment on column BB_MX.NIAN is '年份'; comment on column BB_MX.YUE is '月份'; comment on column BB_MX.BZ is '上传标志';
prompt
prompt Creating table BB_MX
prompt ====================
prompt
create table BB_MX
(
ID NUMBER(8),
BH NUMBER(10),
MC VARCHAR2(100),
NIAN NUMBER(4),
YUE NUMBER(2),
BZ NUMBER(2)
);
comment on table BB_MX
is '报表明细';
comment on column BB_MX.ID
is '局号';
comment on column BB_MX.BH
is '报表编号';
comment on column BB_MX.MC
is '报表名称';
comment on column BB_MX.NIAN
is '年份';
comment on column BB_MX.YUE
is '月份';
comment on column BB_MX.BZ
is '上传标志';