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"
FOR EACH ROW
Many thanks in advance
(non-OCP, hard-working, jack-of-all-trades Internet application developer )
Hugen Enterprises Pty Ltd