create or replace TRIGGER st_types_actions BEFORE INSERT ON types_actions FOR EACH ROW BEGIN SELECT s_types_actions.nextval INTO :new.p_id FROM dual; END;