create or replace trigger "BI_STDT_TERMS" before insert on "STDT_TERMS" for each row begin if :NEW."TERM_ID" is null then select "STDT_TERMS_SEQ".nextval into :NEW."TERM_ID" from sys.dual; end if; end; /