SOURCE
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;