CREATE OR REPLACE TRIGGER "SPL"."BFR_INS_TEST_TRG" 
    before insert on TEST
    for each row
  
  declare
    cursor test_id_cur is
      select test_id_seq.nextval
        from dual;
  begin
    if :new.my_id is null then
      open test_id_cur;
      fetch test_id_cur into :new.my_id;
      close test_id_cur;
    end if;
  end BFR_INS_TEST_TRG;

  /
  ALTER TRIGGER "SPL"."BFR_INS_TEST_TRG" ENABLE;