文件名称:oracle
介绍说明－－下载内容均来自于网络，请自行研究使用
测试通过的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
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
(系统自动生成,下载前可以参看下载内容)
下载文件列表
oracle编程
..........\createTables.sql
..........\insertTables.sql
..........\函数.txt
..........\竖表转横表.txt
..........\级联修改实现方法.txt
..........\触发器.txt
..........\过程.txt
..........\createTables.sql
..........\insertTables.sql
..........\函数.txt
..........\竖表转横表.txt
..........\级联修改实现方法.txt
..........\触发器.txt
..........\过程.txt