×

Loading...

如果你坚持要用Trigger,可以这样写:

CREATE OR REPLACE TRIGGER UBLOB
BEFORE UPDATE ON USER_PROFILES
--注意是BEFORE,不是AFTER
FOR EACH ROW
BEGIN
:new.CREATE_DATE := SYSDATE;
END
Report