OraFAQ Forum: SQL & PL/SQL » Write a trigger

Home » SQL & PL/SQL » SQL & PL/SQL » Write a trigger - help

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Write a trigger - help [message #604752]

Fri, 03 January 2014 13:59

changshui
Messages: 1
Registered: January 2014

Junior Member

I have two tables, patient and exam; the new data in exam.dose needs to be added to an accumulator in patient.cummulativedose as new.cummulativedose = old.cummulativedose + exam.dose. Patient and Exam tables can be jointed by a third one: patient.x = third.x and third.y = exam.y;

How can I write a trigger to do this? I am new to database admin. Your help is greatly appreciated.

Report message to a moderator