create or replace TRIGGER st_alertes BEFORE INSERT ON alertes FOR EACH ROW BEGIN SELECT s_alertes.nextval INTO :new.p_id FROM dual; END;