TRIGGER--記下資料被異動時間

CREATE OR REPLACE TRIGGER sys_tkt_time
BEFORE
UPDATE
ON sys_tickets
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
begin
:new.timestamp := sysdate;
end;
/