create or replace TRIGGER st_questions BEFORE INSERT ON questions FOR EACH ROW BEGIN SELECT s_questions.nextval INTO :new.p_id FROM dual; END;