create or replace TRIGGER st_travaux_groupes BEFORE INSERT ON travaux_groupes FOR EACH ROW BEGIN SELECT s_travaux_groupes.nextval INTO :new.p_id FROM dual; END;