- Category:
- Oracle
- Tags:
-
[WORD]
- File Size:
- 7kb
- Update:
- 2012-11-26
- Downloads:
- 0 Times
- Uploaded by:
- yyyymind
Description: Have student table student (Student ID sno, name sname, age, sage, University Department dept), curriculum Course (course number cno, course name cname) and enrollment form sc (Student ID sno, course number cno, performance grade), using Oracle PL/SQL language to design a package called pkg_student require: (1) Write program header and the definition of inclusion, which contains functions and stored procedures avgGradePerCourse printAvgGradeCourse. (2) function avgGradePerCourse calculate a course grade point average, must be PL/SQL table (index table) implementation. (3) print out a stored procedure printAvgGradeCourse Department of average scores for each course, you must use cursors. (4) call pkg_student package corresponding function or stored procedure
To Search:
File list (Check if you may need any files):
Oracle--biancheng.doc
Download