CREATE TABLE "STDT_STUDENTS" ( "STUDENT_ID" NUMBER(15,0) NOT NULL ENABLE, "STUDENT_NAME" VARCHAR2(150) NOT NULL ENABLE, "AVATAR" BLOB, "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, "ENABLED" VARCHAR2(1) NOT NULL ENABLE, "AVATAR_MIME_TYPE" VARCHAR2(150), "AVATAR_FILE_NAME" VARCHAR2(240), "AGE" NUMBER, "GRADE" VARCHAR2(150), "TENANT_ID" NUMBER, "DELETED_FLAG" VARCHAR2(1), CONSTRAINT "STDT_STUDENTS_PK" PRIMARY KEY ("STUDENT_ID") USING INDEX ENABLE ) ; CREATE OR REPLACE EDITIONABLE TRIGGER "BI_STDT_STUDENTS" before insert on "STDT_STUDENTS" for each row begin if :NEW."STUDENT_ID" is null then select "STDT_STUDENTS_SEQ".nextval into :NEW."STUDENT_ID" from sys.dual; end if; end; / ALTER TRIGGER "BI_STDT_STUDENTS" ENABLE;