资源描述：
《Oracle 数据库上机试验指导4(答案)》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、实验四代码参考：a)初始化脚本完成用户的创建和相应数据的插入。dropusercsjcascade;createusercsjidentifiedbycsj;grantdbatocsj;commit;conncsj/csjsettermoutoff;setechooff;droptablecourSelc;droptablestudent;droptablecourse;--创建学生表createtablestudent(studidchar(6)primarykey,studnamevarch
2、ar2(16)notnull,genderchar(4)check(genderin('男','女')),addrvarchar2(256));--创建课程表createtablecourse(courseidchar(6)primarykey,coursenamevarchar2(32)notnullunique,teachervarchar2(16),scorenumbercheck(scorein(1,3,5)));--创建选课表createtablecourSelc(recidnumbe
3、r(4)primarykey,studidchar(6),courseidchar(6),scorenumber(2)check(score>=0andscore<=100),constraintfk_studforeignkey(studid)referencesstudent(studid),constraintfk_courforeignkey(courseid)referencescourse(courseid));--插入数据insertintostudentvalues('10000
4、1','李白','男','和平区');insertintostudentvalues('100002','杜甫','男','河西区');insertintostudentvalues('100003','李清照','女','河北区');insertintostudentvalues('100004','蔡琰','女','红桥区');insertintocoursevalues('M1001','数学','奥巴马','3');insertintocoursevalues('J2002','军事理论
5、','拿破仑','5');insertintocoursevalues('S3003','摔跤','普京','1');insertintocourSelcvalues(1,'100001','M1001',70);insertintocourSelcvalues(2,'100001','J2002',60);insertintocourSelcvalues(3,'100001','S3003',80);insertintocourSelcvalues(4,'100002','M1001',75)
6、;insertintocourSelcvalues(5,'100002','J2002',85);insertintocourSelcvalues(6,'100002','S3003',95);insertintocourSelcvalues(7,'100003','M1001',50);insertintocourSelcvalues(8,'100003','J2002',55);insertintocourSelcvalues(9,'100003','S3003',45);insertint
7、ocourSelcvalues(10,'100004','M1001',10);insertintocourSelcvalues(11,'100004','J2002',15);insertintocourSelcvalues(12,'100004','S3003',25);settermouton;setechoon;commit;b)--先创建一个视图VCourSelc【见视图参考】，--然后通过下面代码，将目标输出setserveroutputon;declarecursorcur_stu
8、d_courSelcisselect*fromVCourSelc;typeSTUDDATEISTABLEOFVCourSelc%ROWTYPE;var_stud_tabSTUDDATE;begindbms_output.put_line('姓名科目成绩');var_stud_tab:=STUDDATE();opencur_stud_courSelc;FETCHcur_stud_courSelcBULKCOLLECTINTOvar_stud_tab;foriinvar_stud_tab.first
