create or replace TRIGGER st_annees BEFORE INSERT ON annees FOR EACH ROW BEGIN SELECT s_annees.nextval INTO :new.p_id FROM dual; END;