create or replace TRIGGER st_groupes BEFORE INSERT ON groupes FOR EACH ROW BEGIN SELECT s_groupes.nextval INTO :new.p_id FROM dual; END;