create or replace TRIGGER st_salles BEFORE INSERT ON salles FOR EACH ROW BEGIN SELECT s_salles.nextval INTO :new.p_id FROM dual; END;