create or replace TRIGGER st_edt BEFORE INSERT ON edt FOR EACH ROW BEGIN SELECT s_edt.nextval INTO :new.p_id FROM dual; END;