create or replace trigger "BI_STDT_USERS" before insert on "STDT_USERS" for each row begin if :NEW."USER_ID" is null then select "STDT_USERS_SEQ".nextval into :NEW."USER_ID" from sys.dual; end if; end; /