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?
See Question&Answers more detail:os