资源描述：
《oracle一个建表脚本和相应的数据》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、ORACLE一个建表脚本和相应的数据droptableT_STUDENT;droptableT_COURSE;droptableT_CLASS;droptableT_SCORE;CREATETABLET_STUDENT(StuNovarchar(20)NULL,StuNamevarchar(20)NULL,StuSexvarchar(20)NULL,StuClassvarchar(20)NULL);CREATETABLET_COURSE(CourseNovarchar(20)NULL,CourseNamevarchar(20)NULL);CREATEtableT_CLASS(Cl
2、assNovarchar(20)NULL,Roomvarchar(20)NULL,Adminvarchar(20)NULL);CREATETABLET_SCORE(StuNovarchar(20)NULL,Typevarchar(20)NULL,CourseNovarchar(20)NULL,ScorefloatNULL);insertintoT_STUDENT(StuNo,StuName,StuSex,StuClass)values('0001','LeiZhuan','Girl','001');insertintoT_STUDENT(StuNo,StuName,StuSex,
3、StuClass)values('0002','GuoLiFang','Girl','002');insertintoT_STUDENT(StuNo,StuName,StuSex,StuClass)values('0003','LinJinYu','Girl','003');insertintoT_STUDENT(StuNo,StuName,StuSex,StuClass)values('0004','WangLiHua','Girl','004');insertintoT_STUDENT(StuNo,StuName,StuSex,StuClass)values('0005','
4、LiXingWu','Boy','011');insertintoT_STUDENT(StuNo,StuName,StuSex,StuClass)values('0006','HeYue','Boy','012');insertintoT_STUDENT(StuNo,StuName,StuSex,StuClass)values('0007','LiLiJing','Girl','013');insertintoT_STUDENT(StuNo,StuName,StuSex,StuClass)values('0008','DengLiCai','Girl','014');insert
5、intoT_STUDENT(StuNo,StuName,StuSex,StuClass)values('0009','ZhengYiJin','Boy','021');insertintoT_STUDENT(StuNo,StuName,StuSex,StuClass)values('0010','ChenHuaBo','Boy','022');insertintoT_STUDENT(StuNo,StuName,StuSex,StuClass)values('0101','FengYiPing','Girl','023');insertintoT_STUDENT(StuNo,Stu
6、Name,StuSex,StuClass)values('0102','WuZuFeng','Boy','024');insertintoT_STUDENT(StuNo,StuName,StuSex,StuClass)values('0103','WuSuPing','Boy','001');insertintoT_STUDENT(StuNo,StuName,StuSex,StuClass)values('0104','ZhouZhaoSong','Boy','002');insertintoT_STUDENT(StuNo,StuName,StuSex,StuClass)valu
7、es('0105','FuHuiLing','Girl','003');insertintoT_STUDENT(StuNo,StuName,StuSex,StuClass)values('0106','ChenJiu','Girl','004');insertintoT_STUDENT(StuNo,StuName,StuSex,StuClass)values('0107','ZhangHua','Boy','011');insertintoT_STUDENT(StuNo,StuN
