create or replace TRIGGER st_visibilites BEFORE INSERT ON visibilites FOR EACH ROW BEGIN SELECT s_visibilites.nextval INTO :new.p_id FROM dual; END;