ORACLE一个建表脚本和相应的数据.doc

ORACLE 一个建表脚本和相应的数据 drop table T_STUDENT; drop table T_COURSE; drop table T_CLASS; drop table T_SCORE; CREATE TABLE T_STUDENT ( StuNo varchar (20) NULL , StuName varchar (20) NULL , StuSex varchar (20) NULL , StuClass varchar (20) NULL ) ; CREATE TABLE T_COURSE ( CourseNo varchar (20) NULL , CourseName varchar (20) NULL ) ; CREATE table T_CLASS ( ClassNo varchar (20) NULL , Room varchar (20) NULL , Admin varchar (20) NULL ) ; CREATE TABLE T_SCORE ( StuNo varchar (20) NULL , Type varchar (20) NULL , CourseNo varchar (20) NULL , Score float NULL ) ; insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0001,LeiZhuan,Girl,001); insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0002,GuoLiFang,Girl,002); insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0003,LinJinYu,Girl,003); insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0004,WangLiHua,Girl,004); insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0005,LiXingWu,Boy,011); insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0006,HeYue,Boy,012); insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0007,LiLiJing,Girl,013); insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0008,DengLiCai,Girl,014); insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0009,ZhengYiJin,Boy,021); insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0010,ChenHuaBo,Boy,022); insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0101,FengYiPing,Girl,023); insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0102,WuZuFeng,Boy,024); insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0103,WuSuPing,Boy,001); insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0104,ZhouZhaoSong,Boy,002); insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0105,FuHuiLing,Girl,003); insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0106,ChenJiu,Girl,004); insert into T_STUDENT(StuNo,StuName,StuSex,S