数据库程序代码.docVIP

数据库程序代码 在网上发的文档在我的文档的exercises的文件夹中： 班级信息表： create table class( clno varchar2(5) primary key, dept varchar2(40) not null, grade varchar2(8) not null, branch varchar2(20) not null ); --add comments to the table comment on table class is 班级信息表; --add comments to the columns comment on column class.clno is 班级编号; comment on column class.dept is 专业; comment on colulmn class.grade is 年级; comment on column class.branch is 班级; 2.create table student( sno varchar2(5) primary key, name varchar2(12) not null, age number(2) not null, sex char(1) not null, entrance date, address