SOURCE
create or replace TRIGGER st_programmes_sessions
BEFORE INSERT ON programmes_sessions
FOR EACH ROW
BEGIN
SELECT s_programmes_sessions.nextval
INTO :new.p_id
FROM dual;
END;