CREATE TABLE "STDT_USERS" ( "USER_ID" NUMBER(15,0) NOT NULL ENABLE, "USER_NAME" VARCHAR2(240) NOT NULL ENABLE, "USER_DESCRIPTION" VARCHAR2(2000), "TENANT_ID" NUMBER(15,0), "ADMIN_FLAG" VARCHAR2(1) NOT NULL ENABLE, "CREATED_BY" VARCHAR2(240) NOT NULL ENABLE, "CREATION_DATE" TIMESTAMP (6) WITH LOCAL TIME ZONE NOT NULL ENABLE, "LAST_UPDATED_BY" VARCHAR2(240) NOT NULL ENABLE, "LAST_UPDATE_DATE" TIMESTAMP (6) WITH LOCAL TIME ZONE NOT NULL ENABLE, CONSTRAINT "STDT_USERS_PK" PRIMARY KEY ("USER_ID") USING INDEX ENABLE ) ; CREATE OR REPLACE EDITIONABLE 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; / ALTER TRIGGER "BI_STDT_USERS" ENABLE;