create or replace 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; /