create or replace TRIGGER st_departements BEFORE INSERT ON departements FOR EACH ROW BEGIN SELECT s_departements.nextval INTO :new.p_id FROM dual; END;