CREATE TABLE "STDT_EXAM_LEVELS" ( "LEVEL_ID" NUMBER(15,0) NOT NULL ENABLE, "LEVEL_DEGREE" VARCHAR2(1) NOT NULL ENABLE, "DESCRIPTION" VARCHAR2(240) NOT NULL ENABLE, "CREATED_BY" VARCHAR2(150) NOT NULL ENABLE, "CREATION_DATE" TIMESTAMP (6) NOT NULL ENABLE, "LAST_UPDATED_BY" VARCHAR2(150) NOT NULL ENABLE, "LAST_UPDATE_DATE" TIMESTAMP (6) NOT NULL ENABLE, "TENANT_ID" NUMBER, CONSTRAINT "STDT_EXAM_LEVEL_PK" PRIMARY KEY ("LEVEL_ID") USING INDEX ENABLE ) ; CREATE OR REPLACE EDITIONABLE TRIGGER "BI_STDT_EXAM_LEVEL" before insert on "STDT_EXAM_LEVELS" for each row begin if :NEW."LEVEL_ID" is null then select "STDT_EXAM_LEVEL_SEQ".nextval into :NEW."LEVEL_ID" from sys.dual; end if; end; / ALTER TRIGGER "BI_STDT_EXAM_LEVEL" ENABLE;