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,StuClass) values(0107,ZhangHua,Boy,011);insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0108,WuXiao,Girl,012);insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0109,ChenYan,Girl,013);insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0110,TangShan,Boy,014);insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0201,WangHai,Girl,021);insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0202,ChenJuan,Boy,022);insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0203,ZhengZhi,Girl,023);insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0204,LiuWen,Girl,024);insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0205,ZengKang,Boy,001);insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0206,SunJia,Girl,002);insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0207,WenWen,Boy,003);insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0208,TangHai,Girl,004);insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0209,JiangTong,Boy,011);insert into T_STUDENT(StuNo,StuName,StuSex,StuClass) values(0210,TangJie,Girl,012);insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0001 ,QiZhong,001 , 44.818054 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0001 ,QiZhong,002 , 29.768562 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0001 ,QiZhong,003 , 26.831417 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0001 ,QiZhong,004 , 27.110838 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0001 ,QiZhong,005 , 25.304674 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0001 ,QiZhong,006 , 7.935132 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0001 ,QiZhong,007 , 44.202477 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0001 ,QiZhong,008 , 22.2936 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0001 ,QiZhong,009 , 30.486271 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0001 ,QiZhong,010 , 38.653988 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0001 ,QiMo,001 , 38.948986 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0001 ,QiMo,002 , 2.2781785 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0001 ,QiMo,003 , 55.144432 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0001 ,QiMo,004 , 63.06926 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0001 ,QiMo,005 , 11.176199 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0001 ,QiMo,006 , 31.812429 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0001 ,QiMo,007 , 9.0526333 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0001 ,QiMo,008 , 35.622066 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0001 ,QiMo,009 , 74.22982 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0001 ,QiMo,010 , 4.3745823 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0002 ,QiZhong,001 , 23.182283 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0002 ,QiZhong,002 , 38.847477 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0002 ,QiZhong,003 , 45.613705 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0002 ,QiZhong,004 , 56.564404 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0002 ,QiZhong,005 , 42.32222 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0002 ,QiZhong,006 , 20.736492 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0002 ,QiZhong,007 , 22.676846 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0002 ,QiZhong,008 , 53.55695 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0002 ,QiZhong,009 , 95.907425 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0002 ,QiZhong,010 , 65.817101 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0002 ,QiMo,001 , 16.296963 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0002 ,QiMo,002 , 82.055466 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0002 ,QiMo,003 , 10.47953 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0002 ,QiMo,004 , 90.580101 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0002 ,QiMo,005 , 59.848373 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0002 ,QiMo,006 , 12.932973 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0002 ,QiMo,007 , 84.527237 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0002 ,QiMo,008 , 95.200409 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0002 ,QiMo,009 , 89.052681 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0002 ,QiMo,010 , 86.042572 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0003 ,QiZhong,001 , 37.09977 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0003 ,QiZhong,002 , 97.956711 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0003 ,QiZhong,003 , 47.2103 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0003 ,QiZhong,004 , 23.065075 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0003 ,QiZhong,005 , 74.081886 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0003 ,QiZhong,006 , 43.489475 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0003 ,QiZhong,007 , 45.464119 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0003 ,QiZhong,008 , 32.387726 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0003 ,QiZhong,009 , 75.476768 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0003 ,QiZhong,010 , 21.986704 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0003 ,QiMo,001 , 74.553757 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0003 ,QiMo,002 , 25.306978 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0003 ,QiMo,003 , 8.9738798 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0003 ,QiMo,004 , 44.46312 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0003 ,QiMo,005 , 27.180044 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0003 ,QiMo,006 , 60.504013 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0003 ,QiMo,007 , 26.723465 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0003 ,QiMo,008 , 83.22686 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0003 ,QiMo,009 , 22.672525 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0003 ,QiMo,010 , 23.415812 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0004 ,QiZhong,001 , 89.838425 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0004 ,QiZhong,002 , 45.919476 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0004 ,QiZhong,003 , 24.869158 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0004 ,QiZhong,004 , 54.851185 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0004 ,QiZhong,005 , 90.346733 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0004 ,QiZhong,006 , 29.290451 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0004 ,QiZhong,007 , 90.145393 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0004 ,QiZhong,008 , 79.204567 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0004 ,QiZhong,009 , 24.077665 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0004 ,QiZhong,010 , 23.407633 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0004 ,QiMo,001 , 55.668087 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0004 ,QiMo,002 , 87.237656 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0004 ,QiMo,003 , 79.641472 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0004 ,QiMo,004 , 99.844376 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0004 ,QiMo,005 , 37.153999 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0004 ,QiMo,006 , 86.618919 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0004 ,QiMo,007 , 29.183569 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0004 ,QiMo,008 , 4.9874783 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0004 ,QiMo,009 , 27.715025 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0004 ,QiMo,010 , 82.200684 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0005 ,QiZhong,001 , 33.369377 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0005 ,QiZhong,002 , 93.375198 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0005 ,QiZhong,003 , 29.069155 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0005 ,QiZhong,004 , 21.107143 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0005 ,QiZhong,005 , 48.817863 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0005 ,QiZhong,006 , 62.435558 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0005 ,QiZhong,007 , 33.829327 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0005 ,QiZhong,008 , 41.468227 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0005 ,QiZhong,009 , 11.494778 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0005 ,QiZhong,010 , 32.507832 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0005 ,QiMo,001 , 1.2469647 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0005 ,QiMo,002 , 79.127502 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0005 ,QiMo,003 , 62.210468 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0005 ,QiMo,004 , 44.077702 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0005 ,QiMo,005 , 84.031082 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0005 ,QiMo,006 , 96.733635 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0005 ,QiMo,007 , 51.276276 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0005 ,QiMo,008 , 28.509109 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0005 ,QiMo,009 , 38.530144 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0005 ,QiMo,010 , 33.377491 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0006 ,QiZhong,001 , 24.515661 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0006 ,QiZhong,002 , 19.863529 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0006 ,QiZhong,003 , 59.797981 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0006 ,QiZhong,004 , 15.646022 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0006 ,QiZhong,005 , 33.029655 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0006 ,QiZhong,006 , 39.308655 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0006 ,QiZhong,007 , 69.144547 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0006 ,QiZhong,008 , 43.104855 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0006 ,QiZhong,009 , 10.299666 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0006 ,QiZhong,010 , 15.849157 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0006 ,QiMo,001 , 46.862736 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0006 ,QiMo,002 , 83.931351 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0006 ,QiMo,003 , 59.358688 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0006 ,QiMo,004 , 74.954346 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0006 ,QiMo,005 , 67.009605 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0006 ,QiMo,006 , 40.517838 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0006 ,QiMo,007 , 73.845886 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0006 ,QiMo,008 , 28.723398 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0006 ,QiMo,009 , 94.963837 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0006 ,QiMo,010 , 8.877635 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0007 ,QiZhong,001 , 57.92664 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0007 ,QiZhong,002 , 73.656212 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0007 ,QiZhong,003 , 19.882568 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0007 ,QiZhong,004 , 27.329725 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0007 ,QiZhong,005 , 84.676315 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0007 ,QiZhong,006 , 54.285355 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0007 ,QiZhong,007 , 40.337063 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0007 ,QiZhong,008 , 73.302322 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0007 ,QiZhong,009 , 60.576145 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0007 ,QiZhong,010 , 12.337756 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0007 ,QiMo,001 , 20.536158 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0007 ,QiMo,002 , 70.809456 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0007 ,QiMo,003 , 78.109894 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0007 ,QiMo,004 , 52.792992 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0007 ,QiMo,005 , 32.857723 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0007 ,QiMo,006 , 40.494354 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0007 ,QiMo,007 , 27.843655 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0007 ,QiMo,008 , 39.55043 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0007 ,QiMo,009 , 42.04026 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0007 ,QiMo,010 , 34.300419 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0008 ,QiZhong,001 , 38.652245 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0008 ,QiZhong,002 , 21.086662 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0008 ,QiZhong,003 , 34.049477 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(0008 ,QiZhong,004 , 88.386147 );insert into T_SCORE(StuNo,Type,CourseNo,Score) values(