create or replace TRIGGER st_absences_justifiees BEFORE INSERT ON absences_justifiees FOR EACH ROW BEGIN SELECT s_absences_justifiees.nextval INTO :new.p_id FROM dual; END;