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;