CREATE OR REPLACE TRIGGER MYTABLE_AUDIT:INFO BEFORE INSERT OR UPDATE ON "MYTABLE" FOR EACH ROW BEGIN :new.last_user=USER; :new.timestamp=SYSDATE; END; /