create or replace TRIGGER st_fonctions BEFORE INSERT ON fonctions FOR EACH ROW BEGIN SELECT s_fonctions.nextval INTO :new.p_id FROM dual; END;