G'day! I'm trying to update a "timestamp" sort of column in a table, whenever it is updated. It is entered as a default value on insert. The column's name is "UpdatedDT".

I must have done something really stupid here... I cannot get the following to compile... can anyone suggest my mistake please?

CREATE TRIGGER "ISPUSER"."UPDATECHILD"
BEFORE UPDATE
ON "ISPUSER"."CHILD"
FOR EACH ROW
BEGIN
SELECT SYSDATE
INTO :new.UpdatedDT
FROM dual;
END

Many thanks in advance
Max Hugen
(non-OCP, hard-working, jack-of-all-trades Internet application developer )