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