oracle学生成绩表的创建,下面是学生成绩表(score)结构说明

-- 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