-- Create table
create table SC_SCORE
(
SC_NUMBER VARCHAR2(8),
SC_NAME VARCHAR2(50),
SC_SEX VARCHAR2(2),
SC_COURSEID VARCHAR2(5),
SC_SCORE VARCHAR2(3),
SC_ISMAKEUP VARCHAR2(2),
COURSEID VARCHAR2(8)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Add comments to the columns
comment on column SC_SCORE.SC_NUMBER
is '学号';
comment on column SC_SCORE.SC_NAME
is '姓名';
comment on column SC_SCORE.SC_SEX
is '性别';
comment on column SC_SCORE.SC_COURSEID
is '课程号';
comment on column SC_SCORE.SC_SCORE
is '分数';
comment on column SC_SCORE.SC_ISMAKEUP
is