create or replace TRIGGER st_criteres BEFORE INSERT ON criteres FOR EACH ROW BEGIN SELECT s_criteres.nextval INTO :new.p_id FROM dual; END;