搜索资源列表
Oracle--biancheng
- 设有学生表student(学号sno, 姓名sname, 年龄 sage,系别dept)、课程表Course(课程号cno,课程名称cname)和选课表sc(学号sno,课程号cno,成绩grade),用Oracle PL/SQL语言设计一个名为pkg_student程序包,要求: (1)写出程序包头和包体的定义,其中包含函数avgGradePerCourse和存储过程printAvgGradeCourse。 (2)函数avgGradePerCourse计算某门课程的平均成绩,必须用P
Oracle_scott_emp_dept
- Oracle数据库学习时的练习收索语句,scott模式下的emp表和dept表的搜索,仅供参考。-oracle scott emp dept
An-Introduction-to-Database-Systems
- A First Course in Database Systems Jeffrey.D.Ullman, Jennifer Widom Dept. Of Computer Science Stanford University -A First Course in Database Systems Jeffrey.D.Ullman, Jennifer Widom Dept. Of Computer Science Stanford University
lab1
- I. Query with SQL Server 2005. (30’, 2’ for each) 1. Create a table named Student using command Create Table. The table structure is as follows: Column Type Length Note ID Varchar 20 Student’s ID Name Varchar 10 Student’s Name Age Int Stud