create or replace trigger "BI_STDT_TENANTS" before insert on "STDT_TENANTS" for each row begin if :NEW."TENANT_ID" is null then select "STDT_TENANTS_SEQ".nextval into :NEW."TENANT_ID" from sys.dual; end if; end; /