CREATE OR REPLACE TRIGGER QUESTION_DATE BEFORE INSERT ON QUESTION FOR EACH ROW BEGIN :NEW.CREATED_TIMESTAMP := SYSDATE; END;