新建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 10 10 initrans 1 11 maxtrans 255 12 storage 13 ( 14 initial 64K 15 next 1M 16 minextents 1 17 maxextents unlimited 18 ); 19 -- Add comments to the table 20 comment on table COURSE 21 is '课程表'; 22 -- Add comments to the columns 23 comment on column COURSE.cno 24 is '课程号（主键）'; 25 comment on column COURSE.cname 26 is '课程名称'; 27 comment on column COURSE.tno 28 is '教工编号（外键）';
结果：
