trigger which update another table?
2823391Sep 9 2010 — edited Sep 9 2010Hi All,
I am trying to make a trigger on tableA:
Column Name ID Pk Null? Data Type Default
TITLE 1 Y VARCHAR2 (5 Char)
FULLNAME 2 Y VARCHAR2 (80 Char)
UNIVERSITYID 3 N VARCHAR2 (9 Char)
APPL_NO 4 N NUMBER (11)
APPL_NO_HASH 5 N VARCHAR2 (4000 Byte)
OFFER_EXPIRATION_DATE 6 Y DATE
APPLICATION_CANCEL_DATE 7 Y DATE
ROOM_HALL 8 Y VARCHAR2 (39 Byte)
ACCEPTED_FLAG 9 Y CHAR (1 Byte)
ACCEPTED_DATE 10 Y TIMESTAMP(6)
RECORD_CREATE_DATE 11 Y TIMESTAMP(6) systimestamp
When the ACCEPTED_FLAG column is updated, i want a trigger to execute and upadate a column with sysdate on another table..
This is what i have so far:
CREATE OR REPLACE TRIGGER INTER_SCHEMA.ACCEPTED_DATE_TRIGGER
AFTER UPDATE
OF ACCEPTED_FLAG
ON schema.ACCOM_OFFER_ACCEPTANCE
REFERENCING NEW AS New OLD AS Old
FOR EACH ROW
BEGIN
insert into table_b (column) values (sysdate) whre id = ??
END;
Any advise would be appretiated.
many thanks