测试通过的oracle编程(给出了表和数据)

1.函数：输入姓名，课程名，成绩

完成对SC表的插入操作

2.级联修改实现方法:两种方法实现级联删除

3.触发器:在Student表中添加一列：sum_avg(总成绩),在SC表中作一触发器，当添加一行之后，将该学生的总成绩相应改变。

4.过程:输入姓名，课程名，成绩.该过程完 成对SC表的插入操作

5.竖表转横表的方法-Test of oracle Programming (give the table and data) 1. Function: Enter the name, course name, grade completion of the SC table insert 2. Cascaded modified implementation methods: two methods achieve cascade delete 3. Trigger Explorer: In the Student table to add one: sum_avg (total score), SC at the table to make a flip-flop, when the add a line after a total score of the students accordingly. 4. Process: Enter the name, course name, grade. The process of completion of the SC insert table 5. Vertical table to horizontal table Ways