新建course表,并添加数据
1 -- Create table 2 create table COURSE 3 ( 4 cno VARCHAR2(5) not null, 5 cname VARCHAR2(10) not null, 6 tno VARCHAR2(3) not null 7 ) 8 tablespace TEST 9 pctfree 1010 initrans 111 maxtrans 25512 storage13 (14 initial 64K15 next 1M16 minextents 117 maxextents unlimited18 );19 -- Add comments to the table 20 comment on table COURSE21 is '课程表';22 -- Add comments to the columns 23 comment on column COURSE.cno24 is '课程号(主键)';25 comment on column COURSE.cname26 is '课程名称';27 comment on column COURSE.tno28 is '教工编号(外键)';
结果: