SOURCE
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;