create or replace TRIGGER st_types_groupes BEFORE INSERT ON types_groupes FOR EACH ROW BEGIN SELECT s_types_groupes.nextval INTO :new.p_id FROM dual; END;