create or replace trigger "BI_STDT_SUBJECTS"   
  before insert on "STDT_SUBJECTS"               
  for each row  
begin   
  if :NEW."SUBJECT_ID" is null then 
    select "STDT_SUBJECTS_SEQ".nextval into :NEW."SUBJECT_ID" from sys.dual; 
  end if; 
end; 
/