Oracle Trigger将数据从一个表复制到另一个表 [英] Oracle Trigger copy data from one table to another
本文介绍了Oracle Trigger将数据从一个表复制到另一个表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
学生表:学生ID,学生姓名,学生联系人
评估:EvalID,评估数字
学生给出每节课的评估,从1-7。我需要创建一个触发器,复制学生信息,如果他们给出评价7,他们给另一个表的评价
我做的是
创建或替换触发器测试
插入后求值
when(eval_number = 0)
Begin
我不知道从这里做什么....任何想法?
解决方案
下面的表格:
CREATE TABLE student(
studentId INTEGER,
student_name varchar2(100),
student_contact varchar2(100));
CREATE TABLE评估(
evalId INTEGER,
eval_num INTEGER,
student_id INTEGER)
创建表eval_audit(
studentId INTEGER,
student_name VARCHAR2(100),
student_contact VARCHAR2(100),
eval_num INTEGER)
当使用7进行评估时,触发从学生插入数据:
CREATE OR REPLACE TRIGGER AIEvaludation
AFTER INSERT ON评估
对于每个ROW
WHEN(new.eval_num = 7)
DECLARE
CURSOR curstudent IS
SELECT studentid,student_name,student_contact
FROM student
WHERE studentid =:new.student_id;
-
vRowStudent curStudent%ROWTYPE;
BEGIN
OPEN curstudent;
FETCH curStudent INTO vRowStudent;
CLOSE curStudent;
INSERT INTO eval_audit
(studentid,student_name,student_contact,eval_num)
VALUES(vRowStudent.studentid,vRowStudent.student_name,vRowStudent.student_contact,:new.eval_num);
END AIEvaludation;
Student table : student ID, student name, student contact
Evaluation: EvalID, Eval number
student gives an evaluation of each lesson, from 1-7. I need to creat a trigger which copies student information, and the evaluation they gave into another table if they give a evaluation of 7
What i have done is
Create or replace trigger test
After Insert on evaluation
when (eval_number = 0)
Begin
I dont know what to do from here.... any ideas? and is my first bit of trigger correct?
解决方案
Following tables:
CREATE TABLE student(
studentId INTEGER,
student_name varchar2(100),
student_contact varchar2(100));
CREATE TABLE evaluation(
evalId INTEGER,
eval_num INTEGER,
student_id INTEGER)
create table eval_audit(
studentId INTEGER,
student_name VARCHAR2(100),
student_contact VARCHAR2(100),
eval_num INTEGER)
Trigger to insert data from student when there is a evaluation with 7:
CREATE OR REPLACE TRIGGER AIEvaludation
AFTER INSERT ON evaluation
FOR EACH ROW
WHEN (new.eval_num = 7)
DECLARE
CURSOR curStudent IS
SELECT studentid, student_name, student_contact
FROM student
WHERE studentid = :new.student_id;
--
vRowStudent curStudent%ROWTYPE;
BEGIN
OPEN curStudent;
FETCH curStudent INTO vRowStudent;
CLOSE curStudent;
INSERT INTO eval_audit
(studentid, student_name, student_contact, eval_num)
VALUES (vRowStudent.studentid, vRowStudent.student_name, vRowStudent.student_contact, :new.eval_num);
END AIEvaludation;
这篇关于Oracle Trigger将数据从一个表复制到另一个表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文