create or replace TRIGGER st_types_programmes BEFORE INSERT ON types_programmes FOR EACH ROW BEGIN SELECT s_types_programmes.nextval INTO :new.p_id FROM dual; END;