create or replace trigger wid_iwm_new_id_tri before insert on web_iwm_data_raw for each row declare -- local variables here begin select WEB_SPLIT_IWM_SEQ.NEXTVAL into :new.id from dual; end wid_iwm_new_id_tri;