Thank you, will look at the reference manual. This is how I've done
it to this point. It runs and the trigger is created but am not quite
sure if its the right thing.
CREATE OR REPLACE TRIGGER QUOTE_TRG
BEFORE INSERT or DELETE OR UPDATE ON QUOTE
FOR EACH ROW
DECLARE
today_date date;
I have a lab assignment that I have been struggling with. We are
using oracle sql. Can someone please help me. See the lab below. I
have done ques 1 - 3 thus far and am now stuck on triggers ques 4 - 6.
THIS IS THE LAB:
1. Create a table called QUOTE.
ยท Give the table an initial and n
Do you have access to the SQL Reference Manual:
http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/db2/rbafzmsthctri
gger.htm#HDRHCTRIGGER
There's an example of what you want to do:
CREATE TRIGGER SAL_ADJ
AFTER UPDATE OF SALARY ON EMPLOYEE
REFERENCING OLD AS OLD_EMP
NEW AS NEW_E
