create or replace TRIGGER st_qcms_rendus BEFORE INSERT ON qcms_rendus FOR EACH ROW BEGIN SELECT s_qcms_rendus.nextval INTO :new.p_id FROM dual; END;