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