modifying a column

[mnicoras]

Hi,
try this:
CREATE OR REPLACE TRIGGER TI_EMP__ACTIVITY_ID
BEFORE INSERT ON EMP
FOR EACH ROW
BEGIN
IF :NEW.ACTIVITY_ID IS NULL THEN :NEW.ACTIVITY_ID:='000'; END IF;
END TI_EMP__ACTIVITY_ID;