create or replace trigger dcs_batch_id_tri
before insert into on dcs_collect_batch
for each row
when (new.dcs_id is null)
begin
select dcs_collect_batch_id_seq.nextval into :new.dcs_id from dual;
end;
